Drag Formula but Maintain References

hi im thinking of using vlookup for this but i cant copy the formula and drag. it doesnt do that for some reason. is there a reason

can someone help me thanks a lot

-kai

Just use absolute references in your formula like this:

Please Login or Register  to view this content.

@kai, please be sure to title your threads appropriate going forward in line with Forum rules, in short thread titles should:

-- Accurately and concisely describe your problem
-- Use terms appropriate to a Google search

On this occasion given your board experience etc I've modified for you on this occasion.

Thanks in advance for your continued co-operation.