Index Match ?

[VegasL]

Hello,

I'm trying to compare Column A against Column G, and if value in column A is not in column G, then lookup column B, and match it to column, G, and display results from column H, else ""

Desired Result in Column C.

Please see attached spreadsheet.

Thanks

[TMS]

I don't think all your examples are correct, but try this:

Please Login or Register  to view this content.

Regards, TMS