Hi all, this question has probably been asked many times before but if somebody can help me out or point me in the right direction, I would be most appreciative. (All the info on this forum is a bit daughnting for me).
Basically, I have two sheets.
Sheet one has a row like this (Kate being A1):
---------------------------
Kate | "X" | 'OUTPUT'
---------------------------
Joe | "X" | 'OUTPUT'
---------------------------
Mary | "X" | 'OUTPUT'
---------------------------
Don | "X" | 'OUTPUT'
---------------------------
Simple enough. "X" will be a number...in this example, a year. Output is linked to the next sheet...in this example, a weight.
Sheet two has a setup like this (except in reality much more complicated...like 3500 entries) (NAME being in the corner A1, other corner is C8)
-----------------------------
NAME | YEAR | WEIGHT
-----------------------------
Mary | 1990 | 34
-----------------------------
Mary | 1992 | 42
-----------------------------
Joe | 1988 | 16
-----------------------------
Joe | 1990 | 24
-----------------------------
Joe | 1992 | 35
-----------------------------
Kate | 1990 | 15
-----------------------------
Kate | 1992 | 23
-----------------------------
Don | 1992 | 53
So really I just would like to know a formula so that whatever goes in 'OUTPUT' in sheet one recognizes the name and the year I insert to give me the correct weight listed on sheet two.
Again, any help would be most appreciated. Thank you!
Bookmarks