Forum Discussion
Solved
VLOOKUP on a table selected by a dropdown...
Hello, I’ve got a question, is it possible in Excel 365 to obtain a number on a cell of a VLOOKUP on a worksheet which is selected by a dropdown…? Here is what I am trying to do: In a worksheet ca...
You omitted a closing parenthesis. And you shouldn't include the literal sheet name - it is already referenced in cell B5.
=VLOOKUP(B35,INDIRECT("'"&B5&"'!A21:E36"),5,FALSE)
Let's say that:
The lookup value is in cell A2.
The drop down is in cell B2.
The lookup range is the same on both sheet A and sheet B: A2:D100.
You want to return a value from column D.
=VLOOKUP(A2, INDIRECT("'"&B2&"'!A2:D100"), 4, FALSE)
- Hi Hans,
thanks for your reply, I've tried your formula but it dosn't work... I must be doing something wrong... it returns "You've entered too many arguments for this function".
Here's what I typed:
=VLOOKUP(B35,INDIRECT("'"&B5&"'sheet_B!A21:E36",5,0)You omitted a closing parenthesis. And you shouldn't include the literal sheet name - it is already referenced in cell B5.
=VLOOKUP(B35,INDIRECT("'"&B5&"'!A21:E36"),5,FALSE)
HansVogelaar awesome!!! thanks a lot, now is all working
