Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup Mutiple Values | Excel Discussion (Misc queries) | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
Combining mutiple columns into one column | Excel Worksheet Functions | |||
Vlookup/match/offset over multiple columns of lable | Excel Discussion (Misc queries) | |||
how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) |