lookup tables

[Guest]

I want to do a vlookup referencing to two values, cell a4 and d4 as both must be true to return a value. Does anyone know if this can be done and what formula I would use

Thanks

 

[CLR]

It can be done with Concatenation. First Concatenate all combinations of
your two cells and put these values in a column as your leftmost in the
VLOOKUP table, then use something like........

=VLOOKUP(A1&A2,MyTable,2,FALSE)

Vaya con Dios,
Chuck CABGx3

I want to do a vlookup referencing to two values, cell a4 and d4 as both

must be true to return a value. Does anyone know if this can be done and
what formula I would use.