| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH & INDEX ISSUE?
I have a table with agents in column A, with various rates for various
services in Columns B-F. I want to look up agent X and service Y and have the cell return the correct rate. Pretty simple, but I'm stumped! HELP! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH & INDEX ISSUE?
B1:G1 = services
A2:A10 = agent names A12 = agent name to lookup in table B12 = service to lookup in table =VLOOKUP(A12,A1:G10,MATCH(B12,A1:G1,0),0) -- Biff Microsoft Excel MVP wrote in message ... I have a table with agents in column A, with various rates for various services in Columns B-F. I want to look up agent X and service Y and have the cell return the correct rate. Pretty simple, but I'm stumped! HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match issue | Excel Worksheet Functions | |||
| VLOOKUP/Index&Match data format issue | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Linear Mode
