I have a spreadsheet with 1000 rows of data. I need to update only 90 of them with a vlookup. Can I combine an IF and Vlookup combo so that those 90 rows are updated, but the other 900 do not return N/A values and keep their original values? How do I do that?
Bookmarks