MATCH & INDEX ISSUE?

M

merubenstein

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!
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 19
lookup tables to muliply various hourly rates 0
Index and match across columns 5
Match / Index off two "keys" 5
Lookup Y&X show Z but only in A & B are correct 1
How to determine cursor location? 4
Amazon S3 and SES Down 6
Index and match 2

Top