Vlookup with paste special. Is there such a thing?

JustmemyselfandI

New Member
Joined
Mar 7, 2021
Messages
2
Platform
  1. MacOS
Evening all.

Hoping you knowledgeable people can help me out with my query.

So, I have developed a stock sheet, but have found a critical flaw with it.

on picture one, you will see I have the stock item description and then the sku for that item. The part description doesn't change and will be repeated through the sheet but the SKU will change due to the expiry date difference. This gets inputted on sheet 1 as per the top picture below.

On sheet 2, when you input the description it pulls through the sku, all well and good. The problem is it then changes all of the old SKUs to the new one. Is there a way round it doing this? I want ti to pull the most recent sku through but I want it to leave the rest of the data alone.

Screenshot 2021-03-07 at 18.46.04.png
 

Attachments

  • Screenshot 2021-03-07 at 18.46.44.png
    Screenshot 2021-03-07 at 18.46.44.png
    109.5 KB · Views: 4

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,224,027
Messages
6,175,990
Members
452,693
Latest member
Dethpod1

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
Back
Top