I AM USING GOOGLE SHEETS, NOT SURE IF THIS IS THE BEST PLACE TO POST BUT FOR CLARIFICATION!
Hi there, I am attempting to index the contents of a cell and use that as the range in my VLOOKUP formula.
The formula is
Explaining the formula... The search key is the Employee Name which comes from a dropdown in B4. The Range is B2, which is a dropdown for my four sheet names (Test1, Test2, Test3, Test4) The idea is to index column 2 in the sheet value of B2 (test1,2,3 or 4) and return the result of Sam (employee name).
Every time I try, it returns 'Unresolved sheet name B2.
I have tried using INDEX(B4) in replacement of B4 but still no luck. Attached is a photo for reference.