I am working w/ a spreadsheet that has two sheets. On sheet 1 column A is a list of part #'s. Column B is currently empty but needs to have a list of their corresponding sizes.
On sheet 2 I have a master list of part #'s w/ thier sizes. All the part #'s are listed in column A. All the sizes are listed in column B.
I need a formula to enter in to sheet 1/column B that finds the correct sizes from sheet 2. Hope that makes sense. Any help is much appriciated!
rebyrd,
Welcome to the forum!
It sounds to me like what you're looking for is the VLookup() Formula. Using the information you provided, you would put this formula in Sheet1 cell B2 and copy down:
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Fantastic. Thanks a lot. Works perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks