On your Tab 1, are there "groups" of data like this for each person?

Tab 1
Age
Weight
Name
Height

If so, does each group of data follow the same pattern?

Biff

"fgbdrum" wrote in message
...
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.