Hi - thanks to Excel Forum's help I managed to create a vlookup earlier. I now need to copy the same vlookup to subsequent rows below. However first correct row formula is
=VLOOKUP(A1,Sheet1!A1:B187,2,FALSE)
when I copy and paste this to the next row it changes to:
=VLOOKUP(A2,Sheet1!A2:B188,2,FALSE)
I need it to read
=VLOOKUP(A2,Sheet1!A1:B187,2,FALSE)
?
Ps I am a beginner to Excel formulas so need simple explanation! Thank you.
Use absolute references. Hence
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi bankcott,
This is what I stated here in post #6.
HTH
Regards, Jeff
Brilliant - thank you so much for your quick reply this worked a dream!
Sorry Jeff - you did but I didn't spot this. Apologies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks