| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find matching cell and return value of a different cell
I have a workbook with 200 sheets. I have a summary page with a list (in column B) of unique values that correspond with cell A4 on my other sheets. I would like column C of my summary page to find the sheet that has the same value as column B in cell A4 of a sheet and then return the value of A16 from that sheet.
Example: Sheet "Summary" B2 = "1343345". Sheet "Client5" A4 also = "1343345" so it returns Client5 A16 (which is $57,467.13) to C2 on Summary Sheet. Thanks is advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find next up matching cell? | Excel Worksheet Functions | |||
| find cell with matching text, then reference cell in same row | Excel Worksheet Functions | |||
| Return all matching cell values | Excel Programming | |||
| Find Matching Cell and Copy Cell Content in same Row | Excel Programming | |||
| Sorting and Matching criteria across rows to return a result in the last cell | Excel Worksheet Functions | |||
Threaded Mode
