'VLOOK-up without N/A and 0 results (extraction from 2 sheets)
I am trying to create an if-vlookup that retrieves data from 2 sheets with following specs:
- if the retrieve from the 1st sheet shows N/A and 0 results than vlookup from the 2nd sheet;
- if the the 2nd vlookup retrieves N/A and 0 results than change them with blanks.
Solution 1:[1]
Use IFERROR to pass processing on a failed lookup.
=iferror(vlookup(a1, sheet1!A:B, 2, false), iferror(vlookup(a1, sheet2!A:B, 2, false), ""))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |