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 |