Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find cell with matching text, then reference cell in same row
I have a main sheet and many additional sheets with peoples
names' (each sheet is named for a person - including a command and space). The main sheet is named 'Master Inventory' On the main sheet, there is a row for each person. Column A has the names of all the named sheets. Each person named sheet has a cell, A6, with it's sheet name. I would like a specific cell in each named sheet to reference the cell in 'Master Inventory'!<row with the name in cell A6, <column AK example: Master Inventory cell A12 has the name 'Smith, Joe'. I would like a cell in sheet 'Smith, Joe' to be the contents of master inventory cell AK12. I would like to use the same formula on each sheet. How can I do this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Find Cell Reference | Excel Worksheet Functions | |||
Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
find a cell matching separate column and row values | Excel Worksheet Functions | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
Finding the cell reference of a matching search value | Excel Worksheet Functions |