Vlookup to choose two fields
 

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

Vlookup to choose two fields
 

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.

--
Regards

Roger Govier


wrote in message
ps.com...
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