Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default copy a cell value based on search of another cell

I have a worksheet that has two sheets to it

on sheet A i have a list of product codes and the name of an image that goes
with them

on sheet B i have a list of products codes and the productID number from my
database.

what i need to do is search sheet B for the product code that matches sheet
A and then insert the productID onto sheet A

is there an easy way to do this?

Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default copy a cell value based on search of another cell

You can use VLOOKUP for this, or an INDEX/MATCH combination. Give us
some idea of which columns you are using on the sheets if you want a
specific formula to do it.

Pete

On Nov 12, 5:26*pm, Pendal wrote:
I have a worksheet that has two sheets to it

on sheet A i have a list of product codes and the name of an image that goes
with them

on sheet B i have a list of products codes and the productID number from my
database.

what i need to do is search sheet B for the product code that matches sheet
A and then insert the productID onto sheet A

is there an easy way to do this?

Thanks,


Reply
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
Can I copy a field from another spreadsheet based on search? Faye Excel Worksheet Functions 3 July 17th 08 11:36 PM
Copy row based on cell content billinr New Users to Excel 6 February 21st 07 02:49 PM
Copy contents to cell based on value in second cell Mike Carpenter Excel Discussion (Misc queries) 3 April 21st 06 03:01 PM
Search a cell based on format Al Excel Discussion (Misc queries) 4 May 19th 05 07:02 PM
How to search and copy cell content to another sheet? Roel Excel Worksheet Functions 1 March 7th 05 02:56 PM


All times are GMT +1. The time now is 07:00 PM.

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

About Us

"It's about Microsoft Excel"