Hi, I am not really good with formulas so I need some help. I can do simple formulas, but this one is probably going to be difficult.
I need to compare part numbers on spreadsheet A with the numbers on spreadsheet B and when it finds a match I need it to copy 2 adjacent cells from spreadsheet A to the same columns in spreadsheet B. I have never done a formula involving a lookup on a different spreadsheet, so I don't know what is involved. Any help would be appreciated.
Thanks,
Mike
It would be the same formula as when in a single workbook, except you reference the outside source
e.g
=VLOOKUP(A2,'C:\yourfolder\[Book1.xls]Sheet1'!$C$1:$E$14,2,0)
where A2 is the part number to lookup on in your active sheet, and the path, sheet name and table range of your database, the 2 means extract from column 2 in that range...
Change to 3 for the next column
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks