I'm guessing you're referring to the dollar signs in the range references....

Check Excel Help for: range references
View this topic: The difference between relative and absolute references

Post back with more questions.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"*Suzannah*" wrote:

Hi :) can someone please tell me why the dollar sign ($) is necessary in the
VLOOKUP function?