|
|
#3
05-14-2024, 07:07 AM
|
|||
|
|||
VLOOK UP #N/A Error
I worked out the formula, took a while but got there in the end:
=IFERROR(IFNA(VLOOKUP(E2,ElementsData,5,0),VLOOKUP (E2,SchemeData,5,0)),"Not Found") 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error | PLSBRYDOBOY | Excel Programming | 0 | 08-30-2019 12:17 PM |
| Tell me which place the vlookup was successful (within a nested vlookup) | Izzii0x | Excel | 2 | 07-18-2019 10:29 PM |
| How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
 Vlookup error
|
lily | Excel | 2 | 04-24-2015 01:21 AM |
|
VLookup is giving me #N/A error, help with data or formula?
|
ladygogo78 | Excel | 3 | 10-22-2012 12:28 AM |
Windows 10 
Office 2016
Threaded Mode