Vlookup result of a formula for Table Name

[scottkalas]

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

 

[SorryForTheStupidQuestion]

Assuming "SITB_Info" is your table name and M3 = "SITB_info" then this should work:

VLOOKUP(K$19,indirect($M$3),2)

 

[scottkalas]

Thanks for reply. I did as you suggested and I'm now getting #REF !

 

[SorryForTheStupidQuestion]

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:

=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.