IFERROR with VLOOKUP

A Rose

HI there,

I have 2 columns of old data and updated data, e.g. "Name1" & "Name1 Updated"

Can i do a vlookup, and iferror keep old data?

Thank you!

John Jonassen

Should be able to, yes.

=IFERROR(VLOOKUP(Cell, New Range, Return Value Column Number, True/False),VLOOKUP(Cell, Old Range, Return Value Column Number, True/False))

A Rose

@John Jonassen

what's the "Return Value Column Number" that's no formula, right?

thank you!

A Rose

@John Jonassen

Response was:

#INVALID OPERATION

John Jonassen

@A Rose , how can I put this differently cuz I can't make it make sense myself. HA

When you highlight the range you are referencing on a sheet, with the column that your searching in being Column Number 1 (Doesn't matter where it lands), counting to the right, what Column Number is the column you would like your result to be pulling from? That is what I mean by "Return Value Column Number"