Microsoft Office Forums - View Single Post - [Solved] VLOOKUP #N/A Error

Thread: [Solved] VLOOKUP #N/A Error

View Single Post

Old

05-14-2024, 07:07 AM

Shelley Lou Shelley Lou is offline

Shelley Lou is offline

Shelley Lou uses Windows 10

Windows 10 Shelley Lou uses Office 2016

Shelley Lou uses Office 2016

Office 2016

Expert

The original poster

Join Date: Dec 2020

Posts: 259

Shelley Lou is on a distinguished road

Default

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

Reply With Quote