Data search

[correomaster]

Hi there.

I am trying to set up a workbook recording instances. Let's see if I
can manage to explain it properly.

Each worksheet contains a list of names on Column A. Col B to Col V
contain the results of adding diifferent type of instances from each
row from column W onwards. The problem is that the list of names
changes on each worksheet by adding and/or deleting members and the
list of names need to be in alphabetical order.

I would like to have a final "reporting worksheet" that calculates
this large or data for me. I cannot do this by just adding using
absolute references as the rows will change.

The final "reporting worksheet" has the same structure as all previous
worksheets, with a full list of every name found on the rest of the
worksheets on column A and, hopefully, columns B to V containing the
totals from the rest of the worksheets.

Is there a formula which will allow (from the reporting workbook) in
any given cell to identify name in Col A, find it on the others
Columns A and add the value of chosen cells on the same row where the
name on the other Col A is found?

I hope this is clear

Thanks in advance

Jon

 

[RagDyeR]

Sounds like Vlookup should work fine for you.

Check out Debra Dalgleish's web page on the subject:

http://www.contextures.com/xlFunctions02.html
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hi there.

I am trying to set up a workbook recording instances. Let's see if I
can manage to explain it properly.

Each worksheet contains a list of names on Column A. Col B to Col V
contain the results of adding diifferent type of instances from each
row from column W onwards. The problem is that the list of names
changes on each worksheet by adding and/or deleting members and the
list of names need to be in alphabetical order.

I would like to have a final "reporting worksheet" that calculates
this large or data for me. I cannot do this by just adding using
absolute references as the rows will change.

The final "reporting worksheet" has the same structure as all previous
worksheets, with a full list of every name found on the rest of the
worksheets on column A and, hopefully, columns B to V containing the
totals from the rest of the worksheets.

Is there a formula which will allow (from the reporting workbook) in
any given cell to identify name in Col A, find it on the others
Columns A and add the value of chosen cells on the same row where the
name on the other Col A is found?

I hope this is clear

Thanks in advance

Jon