Copy Formulas Down

[Doctorbob]

I am doing a workbook to record club scores using a number to identif
all members. The vlookup is sellecting data from 5 work sheets and fro
100 members. The member number is at the start of the formula. I ca
copy and post from the function bar, that keeps my lookup area's righ
but I then have to manully go through and change each of the referenc
field id's so it looks up the sellected member. Is there any way o
copying this formula down and keeping the lookup area's the same.

=(VLOOKUP(A2,'
Arrow'!O2103,2,FALSE))+(VLOOKUP(A2,ABA!O2103,2,FALSE))+(VLOOKUP(A2,'3D'!O2103,2,FALSE))+(VLOOKUP(A2,Delta!O2103,2,FALSE))+(VLOOKUP(A2,IFAA!O2103,2,FALSE))

I need the "A2" to change as the formula is copied down, but I do no
want the rest of the formula to change.

Is there an easy solution.

St

 

[Norman Harker]

Hi Doctor Bob!

Try:

=(VLOOKUP(A2,'3Arrow'!$O$2:$P$103,2,FALSE))+(VLOOKUP(A2,ABA!$O$2:$P$10
3,2,FALSE))+(VLOOKUP(A2,'3D'!$O$2:$P$103,2,FALSE))+(VLOOKUP(A2,Delta!$
O$2:$P$103,2,FALSE))+(VLOOKUP(A2,IFAA!$O$2:$P$103,2,FALSE))

The $ signs fix the reference to the VLOOKUP tables


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Harald Staff]

Hi Stu

Replace all
O2103
with
$O$2:$P$103