Thank you for responding.

What is the separator for the two values? Comma, semicolon?
--
Robert Robinson


"Sheeloo" wrote:

If you have only a few values then use IF otherwise VLOOKUP...

Since you have two conditons... combine them (in the lookup range) in one
column with A1&B1
the in VLOOKUP lookup on A1&B1

"Robert Robinson" wrote:

I have a 3 column list. Two columns have criteria which must be true in order
to select the value of the third (numeric) column. For example:

Sheet 1
Col 1 Col2 Amount
CF AMI 1000.00
CI AMI 230.00
CF BLV 1500.00
CI BLV 160.00

I want to insert these values in a separate sheet, according to my selection
rules, for example:

Sheet 2
Cell A6 If column 1 = CF and column 2 = AMI insert contents of column 3
Cell A7 If column 1 = CF and column 2 = BLV insert contents of column 3
Cell B6 If column 1 = CI and column 2 = AMI insert contents of column 3
Cell B7 If column 1 = CI and column 2 = BLV insert contents of column 3

This is a very simple query, but my issue is that I am not sure if I should
use a lookup or a nested IF statement, or if there is another function that I
should use instead. Please advise.
--
Robert Robinson