Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fgbdrum Fgbdrum is offline
external usenet poster
 
Posts: 18
Default Formula Help

Hi.

Spreadsheet has 2 tabs:

Tab 1 Tab 2
Age Name
Weight Age
Name Weight
Height

In Tab 3 in cell A1, I want to put a formula that says:

-If name on tab 1 matches name on tab 2; AND age on tab 1 matches age on
tab2, AND weight on tab 1 matches weight on tab2, THEN give methe
corresponding height.

Any help is always appreciated. Thanks.