Vlookup2007

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:03 PM GMT

Question

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


Answer

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

Advertisement

©2017 eLuminary LLC. All rights reserved.