View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stickandrock stickandrock is offline
external usenet poster
 
Posts: 18
Default Vlookup based on valid match of mutiple columns

Is there a way to do a vlookup based on a valid match of 2 values on seperate
columns?

Example Data.....
3/12/07 3110 23.23
3/13/07 3110 555.21
3/14/07 3110 46.01

I want to lookup based on a match criteria of 3/13/07 and 3110 and return
the value of 555.21

I know that I could concatenate the 2 columns and do a lookup of the
concatenated column, but I would like to keep the data as it was originally
submitted.

I know it would work that way, but I would like to learn if it could be done
differently without that step.

Thank you in advance for any and all input.