VLOOKUP or maybe INDEX

[mpenkala]

hey gang,

I need a function that will search through a list of numbers, looking to see
if a number in columnA matches any of them. Here's the example:

In E5 I have "BAFE" and in A6 I have the number 26. Now on worksheet2 I
have a table (G2:AF13). In this table I have 12 groups (listed in G2:13).
Each group has 25 numbers in in (H2:AF13, each cell contains 1 number). I
need cell F5 to look through the table and see if the number 26 is in group
BAFE.

If it makes it easier I can reduce the table to 2 column, and list all 25
numbers per group in one cell, seperating them with a comma
(1,2,3,17,19,24...etc).

Thanks again!
Matt

 

[ryguy7272]

Vlookup is a little easier to work with:
http://www.contextures.com/xlFunctions02.html#Arguments
http://www.mvps.org/dmcritchie/excel/vlookup.htm

If that doesn't work for you, and if you are feeling brave, try Index/Match:
http://www.contextures.com/xlFunctions03.html#IndexMatch
http://www.mvps.org/dmcritchie/excel/matchtwo.htm


Regards,
Ryan---

 

[T. Valko]

Try this:

=IF(COUNT(MATCH(A6,INDEX(Sheet2!H2:AF13,MATCH(E5,Sheet2!G2:G13,0),),0)),"Yes","No")