View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Look Up two cells

I have the following table I want to set up in Excel. My question is if a
user keys a Spec and a Spec Gravity number, how do I get Excel to look up the
corresponding intersection of the two numbers.

Spec Spec Gravity
1.01 1.02 1.03 1.04 1.2
1058TT 3.38 3.343 3.35 3.7 3.94
2534C 4.58 4.67 4.75 4.8 5.08
1058TC 3.97 3.99 4.02 4.05 4.75

What kind of formula would work best for this application.
Thanks



--
Kim