VLOOKUP with IF statement to find next match

[cardminger]

Hey guys!

I am working on a sheet to do rolling purchase orders and here is what I am trying to accomplish -

I would like VLOOKUP to find the first match in another sheet where a certain condition is met. So essentially -

Lookup first value for SKUXYZ, if found, check column C, if column C is "False" - find the next value that matches SKUXYZ. If column C is "True", return the value for the VLOOKUP.

Is something like this possible?

 

[kweaver]

Welcome to Mr. Excel,
Please update your profile to indicate which version of Excel you run. Would you also post a few examples using XL2BB?