If(match function

[sREM43]

Hey there, trying to use a function for a cell to check f4 on this sheet against a different tabs list of ID numbers. If there's a match, I want it to say "blank". If there's not a match I have a separate If function that is in the false section of the first. So far I can't get it to work just right, any suggestions?

Basically if the ID is on the list nothing else needs to be done except notify the excel user, if the ID isn't on the list I have a separate formula that calculates some pricing information of the the column in H. If you need more information please let me know. Thanks!

 

[awoohaw]

try:

=IF(ISNUMBER(match(value,listofvalues,0))=FALSE,"blank",IF(conditioncheck,if true, if false))

 

[sREM43]

try:

=IF(ISNUMBER(match(value,listofvalues,0))=FALSE,"blank",IF(conditioncheck,if true, if false))

I think we're really close, this is the whole formula I'm trying to use. The 2nd IF statement I was previously using alone and it worked fine. The first IF statement seems to be the problem. Basically before the 2nd one gets to do anything I want the first one to check f4 and if there's a match no impact if no match 2nd IF statement. (The ID it's checking in column F are alphanumeric if that makes a difference. Please let me know what I can do differently here. Thanks!

=IF(ISNUMBER(MATCH($f4,'List',o))=FALSE,"No Impact",IF(ISERROR(VLOOKUP($H4,'DifferentList',3,FALSE)),0,VLOOKUP($H4,'Same as 2nd list',3,FALSE)))

 

[sREM43]

I changed the =FALSE to =true and that seems to have made it work

 

[awoohaw]

yeah, I read your statement wrong. It is seldom if there a match with something that someone wants to see "blank". So my bad, and thanks for working through the formula.

Welcome to the forum, and

Best Wishes!