Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

=VLOOKUP(B1&A3,'cstmr data'!1:65536,8,FALSE) hi, I am unable to drag this formula to other cells in the same column. I need cell B1 to remain static and cell A3 would correspond to the given row. please advise. thank you very much in advance

share|improve this question

You need to check out absolute references.

Placing a $ before the letter or number in a cell reference stops Excel from changing the reference as you copy the formula. So you need to alter the formula to

=VLOOKUP($B$1&A3,'cstmr data'!1:65536,8,FALSE)
share|improve this answer
thanks for answering my question. Your formula format worked for 2 of the formulas, but the other 2 are not outputting data and just outputing the formula, not even with an error. please advise – Nathaniel_613 Sep 13 '10 at 22:57

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .