MrExcel.com - Your One Stop for Excel Tips & Solutions

Selective VLOOKUP

Posted by Patrick Nolan on November 21, 2001 6:34 AM

I want to update values into a column based on another spreadsheet which has a list of changes to those values. I want only the values which require a change to be updated. If I do a simple VLOOKUP, the values which had no changes made to them will get changed to #NA. How do I update the values in my original column without having the rest of the data in that column change to #NA.

Posted by Gary Hewitt-Long on November 21, 2001 10:46 AM

Have you tried nesting the VLOOKUP function with an IF function?

Regards,

Gary Hewitt-Long

Posted by Patrick Nolan on November 21, 2001 2:27 PM

That's where I was trying to go, but I just can't wrap my head around it and figure it out.