Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search a random array of cells and return a value of "X"
Looking for a way to conduct a "LOOKUP" in a random array of cells, ie
A1:A25, B2,B5,C2,C5 find a specific result and return a value of "X" in a specific cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search a random array of cells and return a value of "X"
Not sure if there's a direct way,
but perhaps something along these lines .. In Sheet1, Use 2 empty cols, say: cols E & F to list the sheetnames (in col E) & cell references (in col F), eg: Sheet2, a1 Sheet2, b2 Sheet3, b5 Then put in G1, and copy down: =INDIRECT("'"&E1&"'!"&F1) Col G will return the contents of the cells referenced Then if we have the lookup values listed in A1 down, we could put in B1: =IF(ISNUMBER(MATCH(A1,G:G,0)),"X","") and copy B1 down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "EKB" wrote in message ... Looking for a way to conduct a "LOOKUP" in a random array of cells, ie A1:A25, B2,B5,C2,C5 find a specific result and return a value of "X" in a specific cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Return a cell value based on specific combinations of cells in an array | Excel Worksheet Functions | |||
Return number of cells filled | New Users to Excel |