Thread: vlookup dynamic reference

I am attempting to do a dynamic lookup reference for a worksheet name in a vlookup.

=IF($C8="","",VLOOKUP($C8,WK2!$C6:$H63,5,FALSE))

where WK2 reference for the worksheet name is obtained from a cell reference say G6 ("WK2" value) or G8 ("WK3" value). The reference cells are on the same sheet as the formula above.

Thanks

Originally Posted by tknutsen

I am attempting to do a dynamic lookup reference for a worksheet name in a vlookup.

=IF($C8="","",VLOOKUP($C8,WK2!$C6:$H63,5,FALSE))

where WK2 reference for the worksheet name is obtained from a cell reference say G6 ("WK2" value) or G8 ("WK3" value). The reference cells are on the same sheet as the formula above.

Thanks

=IF($C8="","",VLOOKUP($C8,INDIRECT(G6&"!$C6:$H63"),5,FALSE))

HTH