VLOOKUP or INDEX MATCH HELP (Multiple Columns Lookup)

[mohdabrar]

Hi,

I have two sheets, Sheet 1 and Sheet 2. Sheet 1 has reference values and sheet 2 has data. I have data in columns A,B,C,D in Sheet 2, and I want to lookup and match data from Sheet 1. Here's where it gets tricky- I want the formula to find a match in Column B first and if it can't find match/lookup value, it needs to move to column c and d. In the reference sheet there are just two columns, A & B, looking the value in A and Result value in B. I've tried to combine If and Match and Vlookup but to no avail. Any help is greatly appreciated.

Thanks!

 

[mohdabrar]

It may even be possible with formulas but I'm sure it would be possible with vba but it is not a task I would take on in a free public forum like this.

I understand, Let me know if we can discuss this offline? Or if you offer paid services, how much that would set me back. I know it could be possible, and I am pulling my hair on this one. Thanks!

 

[Peter_SSs]

Let me know if we can discuss this offline?

That is not possible - see #4 of the Forum Rules

Or if you offer paid services, how much that would set me back.

Have a look at the top of the forum: