VLOOKUP or maybe INDEX

  • Thread starter Thread starter mpenkala
  • Start date Start date
M

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
 
Try this:

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