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)
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)
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