Vlookup result of a formula for Table Name

scottkalas

New Member
Joined
Jan 3, 2018
Messages
3
I'm trying to use the result of a formula as the array of a Vlookup formula

In cell K3 I have the value of from a validation list from another workbook

In cell M3 I have the formula =CONCATENATE($K3,"_Info")

In cell K19 I have the value from a validation list from another workbook (same workbook different validation list)

In cell K20 when I use the formula =VLOOKUP(K$19,SITB_Info,2) I get the correct result

In cell K20 when I use the formula =VLOOKUP(K$19,$M$3,2) I get the result #N/A

Is there a way to get the correct result using the 2nd formula or similar

Thanks
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Joined
Sep 7, 2018
Messages
8
Indirect is usually how you get a formula result to act as a look up table so not quite sure why that isn't working. Maybe in a blank cell put this:

Code:
=M3="SITB_Info"
If that returns TRUE then I'm not sure what is needed but if it returns false it'd mean the formula result doesn't match the name of your table range.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,275
Messages
5,467,720
Members
406,549
Latest member
midcoastchris04

This Week's Hot Topics

Top