Copying cell value from sheet1 to sheet2 that has same ID

fayez_MrExcel

Active Member
Joined
Oct 29, 2005
Messages
426
Office Version
  1. 365
Platform
  1. Windows
I have a huge list of Stock Items in sheet1 (Serial No., Product Name, Item Code ID, Location-A, Location-B placed in A1 – E1) and a Stock Register in sheet2 (Item Code ID, Description, Location Name placed in A1-A3).
One (1) item code in sheet2(Stock Register) can have 1 or 2 location names. What I want to happen is to have a click button in sheet1(Stock Items) wherein if the Item Code ID in sheet1 is equal to Item code ID in sheet 2, it will copy the location name (from sheet2) and COPY it to sheet1 under Location-A and Location-B. If Item Code ID in sheet2 has only 1 location name, then the location name will be copied to Location-A of sheet1, but if it has 2 location name then it will be copied to Location-A & Location-B of sheet1.
Please help…thank
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,181,102
Messages
5,928,062
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top