LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Mutiple Values Little Penny Excel Discussion (Misc queries) 2 October 21st 06 04:28 AM
Copy rows of one sheet into mutiple sheets based on column value Wesley Breshears Excel Discussion (Misc queries) 0 October 18th 06 03:19 PM
Combining mutiple columns into one column noelcantona Excel Worksheet Functions 1 October 16th 05 06:18 PM
Vlookup/match/offset over multiple columns of lable csw78 Excel Discussion (Misc queries) 6 June 8th 05 04:39 PM
how do i get mutiple values using vlookup in excel, lookup value . Abhijeet Excel Discussion (Misc queries) 4 May 19th 05 04:30 AM


All times are GMT +1. The time now is 11:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"