LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
goofy11
 
Posts: n/a
Default Vlookup with "many to many" relationship?

Here's what I'd like to do, but am not sure if it can be done in Excel. I
have a worksheet with sales data by month and by item (duplicate months and
duplicate items). In database language, I believe this would be described as
a many to many relationship. I want to do a vlookup (or alternative) for the
month AND the item (2 columns). When it finds the row with the correct month
and item, then return the sales number. Here is a simple example.

Month Item # Sales
May 2222 100
May 4444 200
June 2222 110
June 4444 190

Let's say I want to return the Sales value for item 4444 in May. It needs
to look for May in column A, then look for item 4444 in column B. When it
finds the match, then return the corresponding value in column C. Normally I
would do something like this in Access, but in this case I have been given an
Excel template that I need to use. Can this be done?

 
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 finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 1 November 19th 04 03:49 AM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 08:06 PM
vlookup. Amit Excel Worksheet Functions 2 November 3rd 04 12:34 PM


All times are GMT +1. The time now is 03:13 AM.

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"