Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Need help with a lookup formula using row & column heading:
a b c d Loc 1 Loc 2 Loc 3 Loc 4 1 Cust 1 6 2 18 1 2 Cust 2 8 20 4 6 3 Cust 3 1 1 8 10 4 Cust 4 2 5 5 1 The formula I need would return the value where the row & column meet (ie., return the number where Cust 3 & Loc 2 intersect. Thanks. jen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup value,return column heading | Excel Worksheet Functions | |||
Lookup Value and Return Column Heading | Excel Worksheet Functions | |||
Return Column Heading after lookup | Excel Worksheet Functions | |||
In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
Lookup min & column heading | Excel Worksheet Functions |