BleepingComputer.com: Making Different Excel Worksheets Communicate

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Making Different Excel Worksheets Communicate From Roger P (St Helens UK)

#1 User is offline   Roger P 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 2
  • Joined: 03-November 10
  • Gender:Male
  • Location:St Helens, Merseyside

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**!

This post has been edited by Roger P: 03 November 2010 - 08:35 AM

#2 User is offline   Eyesee 

  • Bleepin Teck Shop
  • PipPipPipPipPipPip
  • Find Topics
  • Group: BC Advisor
  • Posts: 3,446
  • Joined: 15-July 06
  • Gender:Male
  • Location:In the middle of Kansas

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.

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users