try a helper column 5, 8 11
vlookup($b3,sheet1!$a:$cg,c1,0)

--
Don Guillett
SalesAid Software

"LostwithoutLost" wrote in
message ...
As a P.S.

I have tried replacing the 5 at the end with COLUMN(E1),0 but the auto
fill
only increases the increment by 1

Thnaks

"LostwithoutLost" wrote:

Can i use autofill to increase the column count it looks in?
On row 1 for example I have =and i then want
to increment it by 3 in the next column
i.e. =vlookup($b3,sheet1!$a:$cg,8,0) and then
=vlookup($b3,sheet1!$a:$cg,11,0) and so on.

Thanks in your advance for your help