Grabbing the Last name
Nel post
*MABeatty* ha scritto:
Worked like a charm, but to my surprise didn't solve my problem.
Step 2 I have several worksheets that are named by a persons last
name. I wanted to take a total from each of the sheets and display
them on one sheet. The second sheet simeply has "Last, First" in Row
A and a total in Row B. My though was to use to refer to the last
name in the formula to get the last name.
Instead of having =Smith!D20
I could have =LEFT(a1,FIND(",",a1)-1)!D20
where A1 would equal "Smith, Joe"
that way as the list changes I could simply update the name and "Fill
Down" the formula.
I think yo can use the INDIRECT function in this way, if the data you want
is always in cell D20
=INDIRECT("'"&LEFT(B17,FIND(",",B17)-1)&"'!D20")
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|