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