| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find a value in a table and return the cell or column reference
Please help! I need a formula that will allow me to search across multiple
rows and columns and find a match and then return the cell reference or column reference of the match. I can't just use vlookup or hlookup, because they only search the first column or row. Below is an example of the data I will be searching. Each month I get a list of names and a number associated with that name, and I need a formula that will identify which group that number belongs to by searching the data below. GROUP A GROUP B GROUP C GROUP D GROUP E GROUP F GROUP G 00080001 01160001 01160023 00700001 01160007 01160010 01160020 00690001 01160002 01160008 01160018 00690002 01160003 01160009 00690003 01160004 01160011 00690004 01160005 01160012 01500001 01160006 01160013 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a value in a table and return the cell reference | Excel Worksheet Functions | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| return cell reference from any column | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
