If Statement with Vlookup Match

[jws]

Hello,

I need some help with this formula since I can see the reason why it is not working but do not know what to put in the vlookup place to get me the proper result.

=IF(F3=J:J, (VLOOKUP(G3,K:K, 1, FALSE)), "no")

Columns F & G are data values and column H is where I am adding the formula as shown.

Table J thru K is the lookup table. Basically if there is a match between column F & column J, I want to filter out the values that are "no". The problem is with the lookup, rows 4 thru 10 return a false value and I need help on how to display the value as shown.

Thanks

 

[Aladin Akyurek]

Hello,

I need some help with this formula since I can see the reason why it is not working but do not know what to put in the vlookup place to get me the proper result.

=IF(F3=J:J, (VLOOKUP(G3,K:K, 1, FALSE)), "no")

Columns F & G are data values and column H is where I am adding the formula as shown.

Table J thru K is the lookup table. Basically if there is a match between column F & column J, I want to filter out the values that are "no". The problem is with the lookup, rows 4 thru 10 return a false value and I need help on how to display the value as shown.

Thanks

H3, control+shift+enter, not just enter, and copy down:

=IF(ISNUMBER(MATCH(G3,IF($J$3:$J$10=F3,$K$3:$K$10),0)),G3,"no")

 

[jws]

Problem solved, thank you very much!

 

[Aladin Akyurek]

Problem solved, thank you very much!

You are welcome. Thanks for providing feedback.