Lookup function from 2 different cells

[kastaman]

Hi there,

We're trying to create a lookup that refers to 2 different cells but with no luck.
The problem for cell A1 we need a lookup for cell B1 and C1 and depending on the values for each (I have 2 lookup ranges for cell B1 and C1) we should get a result according to the range lookup.

Hope this help in explaining my problem

Thanks in advance,

Kastaman

 

[wmichael]

Could you concatenate b1 & c1, place the result in a new column (hide it if you wish) and use that to key your lookup on? that way you only have to do your lookup on one value.

Be interested to see if this works.

~wmichael

"small change can often be found under seat cushions

 

[SkipVought]

Hi,

Take a look at

http://www.contextures.com/xlDataVal02.html

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[kastaman]

The cells (B1 & C1) have numeric values and through the combination of the value of each cell, cell A1 would have the specific message

Cell
B1
C1

Lookup for B1 (Qty)
1 - OK
2 - OK
3 - 1st Notice
4 - 1st Notice
5 - 2nd Notice

Lookup for C1 (Occurences)
1 - OK
2 - OK
3 - Ok
4 - 1st Notice
5 - 1st Notice
6 - 2nd Notice

Thanks in advance,

Kastaman