Get instant live expert help on I need help with looking down reference

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I want to copy a reference formula using the drag down option keeping the same pattern. i.e copy A1 : A5 down to A100 with the reference changing every 5 rows therefore the same pattern. The reference is on another sheet. When I drag down the formula in skips 5 rows on the reference sheet. I can not see why this is the case.
Solved by B. S. in 24 mins
I am using a vlookup and the reference array is on another sheet. It returns #N/A but in the reference array the value I am looking for is there.
Solved by B. H. in 26 mins
i need add some reference drop down list based on the another cell in google sheet.
Solved by X. L. in 19 mins
I need D columns values through the drop down list based on the C columns values..D values from Master Data base B columns reference No s and C values from Master Data base A columns. In QAD sheet D drop down list values( reference Nos ) should be with in the related plant name in Master Data base sheet plant name( A ) columns.. For the example drop down In QAD sheet D4 cell should shows ,reference with plant 2 in cell C4 ,D4 should include the list of reference, 7 to 25,.pls help..
Solved by M. H. in 25 mins
How to I use relative/abs/mixed cell reference if I want to drag down but I want to array to go one the right instead of down
Solved by V. U. in 27 mins