Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP or maybe INDEX
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP or maybe INDEX
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/xlFunctio...tml#IndexMatch http://www.mvps.org/dmcritchie/excel/matchtwo.htm Regards, Ryan--- -- RyGuy "mpenkala" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP or maybe INDEX
Try this:
=IF(COUNT(MATCH(A6,INDEX(Sheet2!H2:AF13,MATCH(E5,S heet2!G2:G13,0),),0)),"Yes","No") -- Biff Microsoft Excel MVP "mpenkala" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should I use VLOOKUP? IF? INDEX? | Excel Worksheet Functions | |||
VLOOKUP, INDEX, or ....? | Excel Worksheet Functions | |||
Index and vlookup assistance | Excel Worksheet Functions | |||
INDEX? VLOOKUP? | Excel Discussion (Misc queries) | |||
Index Match Vlookup? | Excel Discussion (Misc queries) |