| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am trying to lookup a cell based upon what is in row 3 and colum
I am trying to lookup a cell based upon what is in row 3 and column A. Lets
say in column A I have names, row 3 has a date. How do I get the cell that intersect with those 2 things? I have been playing with: =INDEX(C3:M29,MATCH($A$4,A:A,0))&(MATCH($C$3,3:3,0 )) but I can't figure this out..... Help. Thanx, David. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup tab based on cell reference | Excel Discussion (Misc queries) | |||
| vlookup- is a must that lookup value should be the leftmost colum? | Excel Discussion (Misc queries) | |||
| How to lookup row # based on content of another column's cell | Excel Worksheet Functions | |||
| Formula to lookup last number in colum | Excel Worksheet Functions | |||
| lookup in colum a and compare values in colum b | Excel Worksheet Functions | |||
Threaded Mode
