Vlookup2007

QuestionEdit

I am using office 2007. When I applies vlookup formula in 1st column it gives exact answer but when i drag the same in second/ third column it reflects as #N/A. Please help me to solve the same. Shrawan

AnswerEdit

While dragging the vlookup formula to the remaining columns check whether the Lookup Value is getting changed. Check whether both that is your first column lookup value and the Remaining Columns lookup values are same. I am sure here only you are getting strucked.

While posting your query always provide your formula for giving an exact solution instead of giving the solution on assumption.

Have a look in the below website for Absolute and Relative Cell Reference Clarification:- http://www.cpearson.com/Excel/relative.aspx