# Enter number in blank cell match number on sheet 2 & enter data from adjacent cell

1. ## Enter number in blank cell match number on sheet 2 & enter data from adjacent cell

Hello,
Need some help with a formula, I have a workbook with column A row 1 that is blank and I want to enter a part number in A1 (example 12345) and in B1 have a weight entered from sheet 2.
Sheet 2 would have a list of part numbers in column A 1 thru A 60 and in column B 1 thru 60 would have a weight adjacent to each part number (example 2.5 lb).
When a person enters one of these part numbers from sheet 2 into A1 on sheet 1 the weight matching that part number will auto populate in B1 sheet 1.
Bikeman

2. ## Re: Enter number in blank cell match number on sheet 2 & enter data from adjacent cell

If I unders it correctly you can pit this in B1, =VLOOKUP(A1,sheet2!A1:B60,2,false)

3. ## Re: Enter number in blank cell match number on sheet 2 & enter data from adjacent cell

Thanks for the help Sambo Kid! Worked perfect!

4. ## Re: Enter number in blank cell match number on sheet 2 & enter data from adjacent cell

Great! And thanks for adding to my reputation!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1