Hello,
I want to compare column A with column D. If the word in column A is the same as Column D OR , is the same as column D with 25 attached to it, to Display column E, or else display "-", if none of those conditions are met.
so see attached example. what is formula i would put in column b?
I thought it would be, =IF(A2,VLOOKUP(A2,$D$2:$E$6,1,FALSE),IF(A2&" 25",VLOOKUP($D$2:$E$6,1,FALSE),"-"))
But thats not working..any help would be appreciated.
Thanks
Hi VegasL,
Try this formula:
I could have used MATCH in the first section as well, but a VLOOKUP works just as well (plus it shows you how either method could be implemented).
Please Login or Register to view this content.
Thanks Paul, it works - appreciate it.
It's so complex, I'm afraid I don't understand it.
Is this the correct interpretation:
IF(NOT(ISERROR(VLOOKUP(A2,$D$2:$E$6,1,0))) ..Lookup A2 on D2.E6 range, if an error exists (iserror), then don't display it (NOT), if there is no error, then perform function, VLOOKUP(A2,$D$2:$E$6,2,0)
ELSE
Perform Match Function and look up value A2&" 25", on range d2..e6, if there is a match then display data from range e2..e6
is that right?
=IF(NOT(ISERROR(VLOOKUP(A2,$D$2:$E$6,1,0))),
If VLOOKUP(A2,$D$2:$E$6,1,0) does not result in an error (a match is found), then
VLOOKUP(A2,$D$2:$E$6,2,0),
do the VLOOKUP and show that result; Else
IF(NOT(ISERROR(MATCH(A2&" 25",$D$2:$D$6,0))),
If MATCH(A2&" 25",$D$2:$D$6,0) does not result in an error (a match is found), then
INDEX($E$2:$E$6,MATCH(A2&" 25",$D$2:$D$6,0))
do an INDEX/MATCH to show that result (from column E); Else
"-"))
show "-".
Thanks For The Crystal Clear Explanation, It Helps Alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks