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

Upload a sample worksheet of 10-12 records and a mocked up solution.

__________________
Alan עַם יִשְׂרָאֵל חַי

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")