[X]My Assistant

[petite39]

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.

[arnelgp]

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

[petite39]

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.