Hello everyone!
I am having some issues pasting a vlookup through the spreadsheet in excel 2007. When I enter the vlookup fromulaon the first line and try to copy it through the rest of the numbers that are referenced it brings up #Ref. I can physically go through each line and copy the formula in but that would take a long time. I used to be able to do this with paste special in 2003 but I do not know how to get this to work correctly in 2007.
Thank you so much for your assistance!
See the green cells and drag to right and down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you oekere! Will this formula work if the columns are not in the exact location on the data spreadsheet?
Yes, since we used 0 to determine an exact match (instead of 1, which is the other option)
it will also work if it is nog on a diferant row in the other worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks