Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double Lookup
I have to lookup in two ways and don't know how. I need to lookup a certain
date that is always in B5 but that may change. and a certain name that is always in A5 but that may change. The list shows names and amounts assigned to the point where name and date meets and I need the amount. For example in cell B10 the amount is $5. Cell B5 shows 10-1-2009 and Cell A5 shows james. So I need to look up that james got $5 on the date 10-1-2009. The report is weekly so the pay period ending will change every two weeks. That is where my trouble is. Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Lookup | Excel Worksheet Functions | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
Double LOOKUP? Help please... | Excel Worksheet Functions | |||
double lookup | Excel Worksheet Functions | |||
Double lookup | Excel Worksheet Functions |