vlookup to return Yes and No values

[Junior9]

Is it possible to write a vlookup that will return a value of Yes if the value is true and a value of No if the value is false?

I have data in column A on sheet 1 so the lookup value starts in cell A2 and the table array is on sheet 2 in columns A and B so the column index is 2.

 

[Jayfore]

It was not finding the value, so it would always say NO. I found the issue -- it's because the servername column seems to need to be the first one in the sheet (column A). When I moved it there, it started working. Thanks for the reply!

 

[Aladin Akyurek]

It was not finding the value, so it would always say NO. I found the issue -- it's because the servername column seems to need to be the first one in the sheet (column A). When I moved it there, it started working. Thanks for the reply!

Great. There is no need to switch columns for Index/Match would solve the issue.

 

[Jayfore]

Wonderful -- I am not familiar with this feature. Could you please explain how I would do this? Thank you!

 

[Mike1138]

EDIT: nevermind, ninja'd.

 

[Aladin Akyurek]

Wonderful -- I am not familiar with this feature. Could you please explain how I would do this? Thank you!

If you just need yes/no as outcome, MATCH is enough. Suppose we want to check for A214 against SUBSET!A2:A120, we would just need:

=IF(ISNUMBER(MATCH($A214,SUBSET!$A$2:$A$120,0)),"YES","NO")

 

[Mike1138]

If you just need yes/no as outcome, MATCH is enough. Suppose we want to check for A214 against SUBSET!A2:A120, we would just need:

=IF(ISNUMBER(MATCH($A214,SUBSET!$A$2:$A$120,0)),"YES","NO")

And if you were okay with TRUE/FALSE rather than YES/NO, you could simplify even further: =ISNUMBER(MATCH($A214,SUBSET!$A$2:$A$120,0))

 

[Jayfore]

Perfect -- THANK YOU both! That worked perfectly. I would guess that this takes less processing than using the VLOOKUP command I had been using, so all the better!

 

[Aladin Akyurek]

Perfect -- THANK YOU both! That worked perfectly. I would guess that this takes less processing than using the VLOOKUP command I had been using, so all the better!

You are welcome.