LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 5th 19, 11:08 PM
Junior Member
First recorded activity by ExcelBanter: Nov 2019
Posts: 1
Default Bringing Back Data from one worksheet to another


I have been asked to match some data from one worksheet to another and I can't work out how to do it.

In a nutshell.

in one worksheet I have a column with product ID and next to it the manufacturer, in another I have a column of Product ID that we have sold, but I need to create a blank column named 'Manufacturer' and this should match up the data from the first worksheet.

Does this make sense and can anyone help?

1st worksheet

Prduct ID Manufacturer
1 Dunn
2 Merry
3 Christmas
4 Excel
5 Help

2nd worksheet

Product ID Manufacturer
2 ?
3 ?
3 ?
4 ?
5 ?

Last edited by Mr dunn : November 5th 19 at 11:16 PM

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup bringing back #N/A Afsha Excel Discussion (Misc queries) 2 July 5th 07 01:19 PM
Bringing conditional data from another worksheet Nikki Excel Programming 3 April 1st 07 05:54 PM
bringing data in from another worksheet stacy05 Excel Discussion (Misc queries) 1 February 23rd 07 08:39 PM
bringing data in from one worksheet to another stacy05 Excel Worksheet Functions 0 February 23rd 07 02:51 PM
Bringing quotations back up on screen flymeoutofhere Excel Discussion (Misc queries) 1 October 2nd 06 01:55 PM

All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017