I think you're going to have to provide a more detailed description and
explanation.

Biff

"fgbdrum" wrote in message
...
Not sure what you mean by "groups" but I can tell you that the data on
each
tab does not follow any pattern. Tab 1 has 130 rows worth of info, Tab 2
has
400.

"T. Valko" wrote:

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.