Aug 11 2021 01:46 PM
I am trying to pull data from one spreadsheet to another. I am using a VLOOKUP formula which is working except for those lines that are not finding a match in the second spreadsheet, it is giving me an #N/A error. I need to put a zero in the field if there is no match and I can't figure out how to use the IF and VLOOKUP together to make that work. Can someone help me?
Aug 11 2021 02:08 PM - edited Aug 11 2021 02:09 PM
SolutionMar 09 2022 03:18 PM
Mar 09 2022 05:17 PM
Aug 11 2021 02:08 PM - edited Aug 11 2021 02:09 PM
Solution