View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Formatting challenges in frontpage Formatting challenges in frontpage is offline
external usenet poster
 
Posts: 2
Default 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