LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default VLookUp or other function to return matched data from multiple col

I have raw data that I put into a spreadsheet that I need to match to a
pre-existing "legend".

Legend Set-Up:
Column A - Storefront Name
Column B - Publisher Name
Column C - Placement Name
Column D - Orders

I need to automatically insert data into Column D (Orders) by searching AND
matching (exactly) all three Columns A-C in the "raw data" tab.

I realize that VLOOKUP will only search the first Column in my Legends tab.

Now I am at a complete loss how to achieve the desired outcome.

Any ideas on how to do this would be really appreciated!


 
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
Matching 2 list of data array, and return it as True if matched Venice Excel Discussion (Misc queries) 1 June 19th 09 10:13 AM
Return matched value 2 criteria Diddy Excel Worksheet Functions 4 December 1st 08 10:51 PM
vlookup - return multiple data RBA Excel Discussion (Misc queries) 3 August 8th 07 10:31 PM
VLookUp function to return multiple rows sebastian stephenson Excel Worksheet Functions 7 April 20th 06 06:25 PM
Return Title to matched column [email protected] New Users to Excel 1 February 21st 06 06:04 AM


All times are GMT +1. The time now is 08:22 PM.

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

About Us

"It's about Microsoft Excel"