How to lookup data in Excel?

[GB]

Hello,

I have a spreadsheet for which I need a certain value in a column (D)
based on the value in three previos coulumns (A,B,C), i.e.

Column A ColumnB ColumnC
Sydney Los Angeles Express
Sydney Los Angeles Deferred
Sydney Dallas Deferred
Hong Kong New York Express
Taipei San Francisco Express
Taipei Los Angeles Deferred
Tokyo Los Angeles Express
Manila Dallas Express

Column D
3
5
5
1
2
4
5
2


So if the value of A is Sydney, B is Los Angeles and C is Express,
column D should have a formula that give the value of 3. The value for
column D it will be pulling of a second sheet which contains all
possible combinations. If the combination is not listed on the second
sheet a "N/A" should appearin Column D.

I assume I somehow need to use LOOKUP / VLOOKUP / HLOOKUP, but I am
unsure of how to aproach this. Please help!

Thanks...

 

[Alan Beban]

So if the value of A is Sydney, B is Los Angeles and C is Express,
column D should have a formula that give the value of 3.

How does Excel know that the value in Column D should be 3???

Alan Beban

 

[GB]

Alan,

The value "3" is predefined on the second sheet.
The second sheet has all possible combinations including different
values of Column D.

My sheet 1 one is changing daily and my catch is I want to avoid
having to look up the value of D manually on this sheet.

I hope my request is more clear. Let me know if you have further
questions.

Thanks for assisting.

 

[Alan Beban]

=SUMPRODUCT((Sheet2!$A$1:$A$10=A1)*(Sheet2!$B$1:$B$10=B1)*(Sheet2!$C$1:$C$10=C1)*Sheet2!$D$1:$D$10)

Alan Beban

 

[GB]

Than you very much Alan. You have saved me a lot of time

Regards,