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

Please Login or Register  to view this content.

HTH