Reference based on matching values in another column?

  • Thread starter Thread starter Pat Kopf
  • Start date Start date
P

Pat Kopf

Aloha,
I'm not sure it is possible to do what I am trying to do in
Excel, but I figured I'd ask anyway. I'm working on a stat
spreadsheet and would like to reference cells from another sheet based
on the value of a column. One column on each sheet contains names.
The names on the two sheets may not be in the same order. Is there a
way to reference a value on the second sheet by matching the name in
the row of the two sheets and using an offset? For example if I'm in
cell G10 and the name in cell B10 is Steve, is there a way for me to
put a reference in G10 that goes to another sheet, goes to the row
containing the name Steve, and then copies the value from another
column of the row containing the name Steve? Thanks in advance for
any and all info.

Pat K.
 
Don Guillett said:
Have a look in HELP index for VLOOKUP
Click to expand...

Perfect! And I thought I looked through the help files pretty
thoroughly. I guess I missed that section. Thanks.
 
Back
Top