Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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.
fficeffice" /><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.
