UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Iferror With Vlookup, Office 2013    
 
   
petite39
post Oct 16 2019, 07:29 AM
Post#1



Posts: 1,220
Joined: 7-April 04



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.
Go to the top of the page
 
arnelgp
post Oct 16 2019, 07:54 AM
Post#2



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


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


--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
petite39
post Oct 17 2019, 12:40 PM
Post#3



Posts: 1,220
Joined: 7-April 04



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.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th November 2019 - 09:52 PM