VLOOKUP for Multiple Conditions

[helpmethanks]

Hi,
I am trying to extract data from a long list of records using a vlookup. The issue I am running into is that the matchup needs to be done on more than one criteria i.e. Need to validate if the Store #, Manager Name, Location match rather than just the store #.

I must confess, I am relatively very new to excel but am learning fast - thanks in large amount to this excellent forum. I have posted a few queries and received some tremendous help. Thanks a lot to everyone who is so willing to share their expertise and knowledge.

I have posted a sample file with a few examples of Master List and indicated the Desired Results ..

Thanks in advance !

[Cheeky Charlie]

I have your file open and do not understand your desired results.

What information is fixed, what is found from which table?

Do you want first instance only, or maximum values or what?

[helpmethanks]

Sorry the file was not clear

The Master List (Top Table would be the VLookup Table or Reference Table)

Whereas the Database Records are the ones which need to be matched with the Master List. The Database Records will run into a couple of thousand lines

Think I should have reversed the position of the two tables to help the flow

I am trying to arrive at the Desired result by doing a match on the following criteria

Item #, Sales Price, Location and Store Manager

So in the example item # 1A, need to extract lines from the Database Record where

Item = #1A
Sales Price = $20
Location = ABC
Store Manager = Pete

With this criteria the record in row 12 will be populated in the desired results field as 'All ' criteria are met whereas row 13 will not (as the location doesn't match the master list, even though other criteria are met).

Hope this helps clarify - thanks once again for your help

[Cheeky Charlie]

NP

Simple method:
Add an extra column to concatenate the others so you have a single reference, then look that up...

Insert a column at E:E
E12=A12&B12&C12&D12
copy down

(assuming columns are moved over by one as a result of above)
M20=VLOOKUP(I20&J20&K20&L20,E12:F17,2,0)
copy down

How's that for you?

[helpmethanks]

That looks great - however one slight issue, this pulls up only the record in cell M20 ie the inventory.

I want the entire columns in the Desired result table to be populated with matchup ie item #, sales price, location and store manager - Is that possible

Thanks again

[modytrane]

see the example attached.
values in columns I, J and K need to be filled from the master list, based on column H.
The only item you need to find in datatbse is column L in the attached example.
I am using a similar technique with concatenate function in column F [hidden].
hope this helps.
modytrane

[modytrane]

Forgot to mention that columns I, J, K are filled in with vlookup function based on entry in column H.
I have left H25 blank for you. fill it in with one of htree choices and see the rest of row fill in.
modytrane

[helpmethanks]

Wow that solved the problem - you guys are wonderful !! Made my weekend thanks once again !!