using named range in a formula

[rhombus4]

=VLOOKUP(B2,B2:D5,2,0)Is it possible to have a named range in a formula. On a sheet I have a list of names but want to include them in formula above so that I can copy it manually to each sheetIf sheets were sheet1 sheet2 sheet3 etc how would it be used in formula.Thanks

 

[rhombus4]

Try it like this...
=IF(INDIRECT("'"&A1&"'!C5")="","",VLOOKUP(B$2,INDIRECT("'"&A1&"'!B2:D5"),2,0))

Thanks Biff

 

[T. Valko]

Thanks Biff

You're welcome!