Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Phillycheese5
 
Posts: n/a
Default Vlookup with multiple criteria


Hi,
I have Sheet1 with a list of 10 investment strategies, each with 20+
brokers. Many brokers are listed in several strategies.

I'm trying to do a VLOOKUP that checks for both the strategy and broker
and grab some data for Sheet2. Here's what my dataset looks like
(abbreviated):

Large Growth - Bob (select data to the right is what I need)
Large Growth - Pete
Large Growth - Jack

Small Value - Bob
Small Value - Jack
Small Value - Mike

I tried looking at some past threads (with INDEX, MATCH, etc.) but
couldn't get it to work.
Thanks,
Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=382939

  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

You can do a vlookup with concatenated text, i.e.,
=vlookup(a1&b1,range,column)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Phillycheese5"
wrote in message
news:Phillycheese5.1rcuaj_1119992754.4048@excelfor um-nospam.com...

Hi,
I have Sheet1 with a list of 10 investment strategies, each with 20+
brokers. Many brokers are listed in several strategies.

I'm trying to do a VLOOKUP that checks for both the strategy and broker
and grab some data for Sheet2. Here's what my dataset looks like
(abbreviated):

Large Growth - Bob (select data to the right is what I need)
Large Growth - Pete
Large Growth - Jack

Small Value - Bob
Small Value - Jack
Small Value - Mike

I tried looking at some past threads (with INDEX, MATCH, etc.) but
couldn't get it to work.
Thanks,
Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile:

http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=382939



Reply
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
Sumproduct with a vLookup, multiple criteria Tom F Excel Worksheet Functions 3 May 6th 05 04:28 PM
Can I get the mode, min, and max with multiple criteria? BobT Excel Discussion (Misc queries) 1 February 15th 05 04:20 AM
Can VLOOKUP return multiple answers based on several identical lo. jddtct Excel Worksheet Functions 3 January 11th 05 08:03 AM
VlookUp with Multiple Criteria? Arturo Excel Worksheet Functions 3 December 20th 04 07:59 PM
Multiple Vlookup? changeable Excel Worksheet Functions 0 November 9th 04 12:52 PM


All times are GMT +1. The time now is 06:44 PM.

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"