Multicolumn "VLOOKUP" with lookup values text and numeric

[CPS314]

I imagine this is out there some where, but I could not find. I am looking to "Vlookup" on 2 columns, one contains text the other numbers and if they match the table array, return the desired value in the specified column.

 

[SunnyAlv]

Like This ?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=FILTER(Sheet2!$B$2:$B$100,(Sheet2!$A$2:$A$100=A2)+(Sheet2!$A$2:$A$100=B2))

 

[CPS314]

Maybe my explanation is not clear. The return column is where the formula will return the desired result. I have created a Lookup table (Sheet 2) which has 2 columns, table array match (which is a combination of the Text Column and the Number Column in my Sheet 1) and the desired return value in the table array return column. So verbally, the logic is, look in Sheet 1, text column and number column, if either match Sheet 2, table array match column, then return the value from table array return column into the Sheet 1, return column. In my generic example, Text 1 should return Value B, the Num1 does not have a match. Not sure if this helps.

 

[Fluff]

Did you try the formula I suggested?

 

[CPS314]

View attachment 98642

Like This ?

I tried, the reverse is what I needed. =IFERROR(VLOOKUP(A3,$E$2:$F$7,2,FALSE), VLOOKUP(B3,$E$2:$F$7,2,FALSE)) Thanks!

 

[Fluff]

Did you try what I suggested?

 

[CPS314]

Did you try the formula I suggested?

Yes - thank you, this did not work but the first post with the IFERROR formula did work with some corrections. Appeciate all the support on this site!!!!

 

[Fluff]

In what way didn't it work?