BlackieHamel
Board Regular
- Joined
- May 9, 2014
- Messages
- 91
I have a formula that looks for a value in column A of a subsidiary worksheet and returns the value that is to its right, in column B:
This works fine.
I would like to have the worksheet name, ONA in that example, be a value found in a named cell, targetcell. Here's what I have so far. With targetcell equaling ONA, I wrote this formula:
But that returns an error: "You've entered too few arguments for this function."
I'm guessing I have the quotation marks misplaced. Can someone point me in the right direction? Thanks.
Blackie
Code:
=VLOOKUP(MID(A1,4,3),ONA!A:B,2,FALSE)This works fine.
I would like to have the worksheet name, ONA in that example, be a value found in a named cell, targetcell. Here's what I have so far. With targetcell equaling ONA, I wrote this formula:
Code:
=VLOOKUP(MID(A1,4,3),INDIRECT(targetcell & "!A:B,2,FALSE"))But that returns an error: "You've entered too few arguments for this function."
I'm guessing I have the quotation marks misplaced. Can someone point me in the right direction? Thanks.
Blackie
