Look-up formula based on multiple matching fields

[kevinrmac]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My knowledge of excel formula building is quite novice, so I hope I can articulate my question properly (and interpret any responses that members are kind enough to provide).... <o></o>
My Goal:<o></o>
To create a look up formula that requires to fields to match for a row in order to return a value.<o></o>
For example, I have two worksheets that have one common field (item name). However, there may be multiple rows within that worksheet with the same item number. I want my formula to first look at the item number and then look to see that the quantity field matches on both sheets. If both the quantity & the item number match return the quantity number.<o></o>
I hope this make sense. Thank you in advance for any assistance you can provide.

 

[Trevor G]

Welcome to the forum,

It sounds as though you want to use a mixture of Index and Match. or SUMPRODUCT

Check out this website

http://www.contextures.com/xlfunctions03.html

Or

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[T. Valko]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My knowledge of excel formula building is quite novice, so I hope I can articulate my question properly (and interpret any responses that members are kind enough to provide).... <o></o>
My Goal:<o></o>
To create a look up formula that requires to fields to match for a row in order to return a value.<o></o>
For example, I have two worksheets that have one common field (item name). However, there may be multiple rows within that worksheet with the same item number. I want my formula to first look at the item number and then look to see that the quantity field matches on both sheets. If both the quantity & the item number match return the quantity number.<o></o>
I hope this make sense. Thank you in advance for any assistance you can provide.

Can you post some sample data and tell us what result you expect?

 

[kevinrmac]

Welcome to the forum,

It sounds as though you want to use a mixture of Index and Match. or SUMPRODUCT

Check out this website

http://www.contextures.com/xlfunctions03.html

Or

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

THANK YOU, These links are very helpful