a number of reasons why this isn't good practice, but I think this is the formula you are looking for:
=VLOOKUP(B6, INDIRECT(A6 & "!A4:B6" ),2,FALSE)
a number of reasons why this isn't good practice, but I think this is the formula you are looking for:
=VLOOKUP(B6, INDIRECT(A6 & "!A4:B6" ),2,FALSE)
<<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts
Thank you for your help that is working. What would your recommendation be rather than using this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks