VLOOKUP and IF Statements combined

Hello,

I need to create a vlookup formula but only return the value when a specific condition is met.

in column I on the "Costs& Allowances" tab I need to vlookup based on column B on tab "120913" and only return the value when columns B and C are different on tab 120913.

I tried this formula and it is not working.

=IF('120913'!J11<>'120913'!I11,(IFERROR(VLOOKUP(B7,'120913'!C:AB,8,0),"")),"")

Any help would be appreciated.

Need to return value in column C from "120913" only when it is different than column B.

I don't know how to get sheet "120913" to show all, but one question for you.

What happen if there's multiple/duplicates Product #?

Which one are you going to take?

Reason being, vlookup only takes the 1st instance when it found.

If there are duplicate product#'s they should all have the same values in columns B and C

If that's the case, try this formula

=IF(VLOOKUP($B4,'120913'!$A:$C,2,0)<>VLOOKUP($B4,'120913'!$A:$C,3,0), VLOOKUP($B4,'120913'!$A:$C,3,0), "Same")

coming up #NAME?, I'm double checking the formula but I believe I wrote it exactly as you had it.

I see that one and they should have the same values. I will correct that later. thank you by the way.

A good example of Product number is 68256

But that's what I meant, if there's duplicate Porduct #, and that the values in column B and C are different. Which one do you take? What do you look at to decide which one to take.

e.g. Product # 68256

Copy and paste the formula that I gave you on cell I4 of the "Cost&Allowances" sheet. Please use the file that you've attached to see if the formula works

That worked. Thank you very much!

Glad that I could help. Remember to mark this thread as solved =)