Vlookup to choose two fields

[jpsabourin]

in Vlookup can you choose two field example

in column A1 I have the service "Good"
in column B1 I have the delivery due by time. One would be 07/04/2007
17:00 and the the other would be 07/05/2005 12:00.

How do I get the Vlookup to pick either the "Good" with the time of
17:00 or the "Good" with the time of 12:00 to add a specific formula
in C1

Thanks
JP

 

[Roger Govier]

Hi

One way
Insert a new column at A (it can be hidden afterwards if required) and
use
=B1&"|&C1

Then use the concatenation of B1&"|"&C1 as the value to be looked up in
a range which starts from column A.