|
#1
|
|||
|
|||
VLOOKUP #N/A Error
I'm not very good with Excel and really struggling to get a spreadsheet to work correctly.
I have a summary sheet in which I'm pulling through data for specific columns from two other worksheets within the same workbook and the formula I am using is: =IFNA(VLOOKUP(D2,ElementsData,2,0),VLOOKUP(D2,Sche meData,2,0)) I'd like to add the TRIM function to the formula to check for spaces and also for entries that are not found in either of the two sheets to change #N/A to 'Not Found'. Would really appreciate some help. Many thanks |
#2
|
||||
|
||||
Upload a sample worksheet of 10-12 records and a mocked up solution.
__________________
Alan עַם יִשְׂרָאֵל חַי |
#3
|
|||
|
|||
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 |