Vlookup and return only if no match

Tzippy

I'm having trouble.

I want to do a cross sheet VLOOKUP and return the value from another column ONLY if its no match.

Details: I have a "HRC code" column and a "status in HHAX" column on sheets 1 and 2. If the code on sheet 1 matches code on sheet 2 then I want to get the status in HHAX value from sheet 2 ONLY if it doesn't match the status in HHAX value on sheet 1.

I hope that's clear and that someone can help me bc I'm sitting for the past 2.5 hours trying to figure it out.

Thanks!!

Paul Newcome

Are you able to provide a screenshot of the destination sheet? Are you using a 3rd column to pull this into?

Tzippy

Hi @Paul Newcome !

The destination sheet has the exact same columns. To explain: one sheet is being updated by employees and the other sheet I will import the information directly from another platform and I want to match it to see if there are any errors (If employees didn't update it on the other platform). So the HRC code will always be the same and I want to get a return if the status doesn't match. I hope this helps you help me.

Thanks.

Paul Newcome

Can you provide some mocked up examples?

Tzippy

@Paul Newcome

I tried something like this which gave me an incorrect argument message.

=VLOOKUP([HRC Code]@row, {Master Project for HR Compliance Range 5}, 3, false)

Paul Newcome

Sorry. I meant screenshots with manually entered data that shows what you are wanting to automate through formula.