Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Making Different Excel Worksheets Communicate


  • Please log in to reply
1 reply to this topic

#1 Roger P

Roger P

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:St Helens, Merseyside
  • Local time:03:41 AM

Posted 03 November 2010 - 08:31 AM

Hi Computer Whizzkids! :flowers:
I am scratching my head trying to work out how to do the following:-

I want to be able to type an alphanumeric 'stock code' into an excel spreadsheet (E.G. "C000P8VWCW"), and have it automatically bring up the relevant 'Product Name' in the column next to it upon hitting the return key (E.G. 'PACK OF 10 HIGHLIGHTER PENS').

I know it is possible as an old work colleague did it a few years ago. I think he had a product list in a separate worksheet, that somehow linked into the stock codes. I cant figure out how he did it though.

Help would be much appreciated.
Roger :thumbsup:

Note: I am using vista, with office 2007.
Apologies in advance for being a dumb a**!

Edited by Roger P, 03 November 2010 - 08:35 AM.


BC AdBot (Login to Remove)

 


#2 Eyesee

Eyesee

    Bleepin Teck Shop


  • BC Advisor
  • 3,539 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:In the middle of Kansas
  • Local time:10:41 PM

Posted 03 November 2010 - 12:08 PM

Hi Roger and welcome to the forum!

Im thinking that you want to use the VLOOKUP function for this
See if this helps
In the beginning there was the command line.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users