Search the Lookup table and return result formula

Brew

Well-known Member
How do I create a formula that checks to see if the value in H4 equal any value in the vlookup table m4:m48, if so, then Y, if not then N. I tried the following formula but it gives me N result for both conditions.

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
dK:

Try this and let me know if it works..

=IF(ISERROR(VLOOKUP(H4,\$M\$4:\$M\$8,1,FALSE)),"N","Y")

Hope this helps..

Hi

consider

=IF(COUNTIF(\$M\$4:\$M\$8,H4),"Y","N")

Wigi

.. or this possibly?
=IF(ISNUMBER(MATCH(H4,M4:M48,0)),"Y","N")

Thanks everyone for your assistance on this. Wigi, i went with your solution.

Replies
3
Views
157
Replies
3
Views
326
Replies
5
Views
151
Replies
5
Views
221
Replies
1
Views
153

1,221,199
Messages
6,158,488
Members
451,496
Latest member
pledge8236

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back