Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Microsoft Excel _ Iferror With Vlookup

Posted by: petite39 Oct 16 2019, 07:29 AM

I have the following statement in column IL

=IFERROR(VLOOKUP(IN130,$IO$2:$IS$4312,4,FALSE),"NOT THERE")

I need to add another condition and don't know how.

In the example above let's say the cell in column IO = ABC123 and that the cell in IP = DEF456

Once the lookup is done and found the matching in column IN to the value in column IO, I need it to also look in a few cells over, column IP, there may be a value that I need. Which is a replacement part #. So I need the following value to show up in Column IL,ie: "Part NO. ABC123 is replaced by DEF456".

I'm sure it's a nested if but I just don't know where to put it and how the syntax should be.

Posted by: arnelgp Oct 16 2019, 07:54 AM

if you're goal is to find the matching cell and return the adjacent cell to it, you can
use Index(Match()) combination:

=IError(Index($IP$2:$IP$4312, Match(IN130, $IO$2:$IO$4312, 0)), "NOT THERE")


Posted by: petite39 Oct 17 2019, 12:40 PM

I believe I found the problem but don't know how to correct it.

It looks like some of the values in the cells start with an apostrophe, which you can't see in the cell itself. Only when you click on the cell it show at the top of the screen.

How do I remove an apostrophe from the beginning of all the cell values?

I tried doing a find and replace a couple different ways and that didn't work.