Results from more than one criteria
I am trying to do a selection formula. It is for hardware. I have a
workbook set up where I have different tabs, and I need a part number to
return based upon both size and thickness that is stated by the user.
For example:
Hardware size: 4
Thickness: .231
I need to have the formula (with index and match) find the part number that
will match both of these criteria. I have used index and can get it to
return the first, but not the second.
Thanks, Nancy
|