VLOOKUP #N/A Error

Shelley Lou · #1 04-30-2024, 09:55 AM

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

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