Inserting a value in a cell when 2 others cell match a certain cri
 

Excuse me if this appears a stupid request

Have 2 collums "From" & "To" and wish excel to look up a table that would
match the cell values of these collums exactly then enter the price in the
third collum of the table.
Example
a=Hotel name, b=Airport, want c to be a cost that is shown in a seperate
table that has fthe from, to and cost values
So when I enter the job details on my worksheet it automatically puts in the
price from the other table.

Inserting a value in a cell when 2 others cell match a certain cri
 

Describe this "other table"? It has prices in the body of the table. What
does it have down the left side and across the top? What columns and what
rows? What sheet? Otto
"Roy" wrote in message
...
Excuse me if this appears a stupid request

Have 2 collums "From" & "To" and wish excel to look up a table that would
match the cell values of these collums exactly then enter the price in the
third collum of the table.
Example
a=Hotel name, b=Airport, want c to be a cost that is shown in a seperate
table that has fthe from, to and cost values
So when I enter the job details on my worksheet it automatically puts in
the
price from the other table.

Inserting a value in a cell when 2 others cell match a certain cri
 

would you provide examples on what you want to achieve?
how your seperate table format look like
and where do you find the lookup value the price
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis





"Roy" wrote:

Excuse me if this appears a stupid request

Have 2 collums "From" & "To" and wish excel to look up a table that would
match the cell values of these collums exactly then enter the price in the
third collum of the table.
Example
a=Hotel name, b=Airport, want c to be a cost that is shown in a seperate
table that has fthe from, to and cost values
So when I enter the job details on my worksheet it automatically puts in the
price from the other table.

Inserting a value in a cell when 2 others cell match a certain cri
 

Try this:

If I understand correctly... Try this using four Hotels and four Airports.

INDEX(E9:H12,MATCH(A1,D9:D12),MATCH(B1,E8:H8,0))

Whe
A1 is from this Hotel
B1 is to this Airport
E9:H12 is an index of the Prices
D9:D12 is a column of the Hotels
E8:H8 is a row of the Airports

C1 holds the formula above.

HTH
Regards,
Howard

"Roy" wrote in message
...
Excuse me if this appears a stupid request

Have 2 collums "From" & "To" and wish excel to look up a table that would
match the cell values of these collums exactly then enter the price in the
third collum of the table.
Example
a=Hotel name, b=Airport, want c to be a cost that is shown in a seperate
table that has fthe from, to and cost values
So when I enter the job details on my worksheet it automatically puts in
the
price from the other table.