Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 7th 05, 12:37 PM
Roel
 
Posts: n/a
Default How to search and copy cell content to another sheet?

Hi,

Let's say you have one sheet with a list of products.
Column1 = product name
Column2 = product number

I would like to have a cell on Sheet2, where I can start typing something,
and it would let me see a list based on what I typed so far.
E.g when I type "Volks" it should show a list of all Volkswagen Cars.

If I then choose the value, it should use this value and add the product
number in the cell next to it.

What function should I use, or how can I do this?

Thanks,

Roel

  #2   Report Post  
Old March 7th 05, 01:56 PM
Jason Morin
 
Posts: n/a
Default

One way:

1. Create a unique list of all product names and paste
that list in A2 of Sheet2 (let's assume it's A2:A11).
2. Select A1 and go to Data Validation.
3. Select "List" under "Allow". Under "Source" put:
=$A$2:$A$11
4. Hide rows 2-11 or custom format as ;;;
5. In B1 copy this:
=VLOOKUP(A1,Sheet1!A:B,2,0)
where product names are col. A on sheet1, and product
numbers are on sheet2.

You can begin typing a name in A1 and it fill in when it
finds a match. Or, at any point, press ALT + Down Arrow
to drop down the list.

HTH
Jason
Atlanta, GA


-----Original Message-----
Hi,

Let's say you have one sheet with a list of products.
Column1 = product name
Column2 = product number

I would like to have a cell on Sheet2, where I can start

typing something,
and it would let me see a list based on what I typed so

far.
E.g when I type "Volks" it should show a list of all

Volkswagen Cars.

If I then choose the value, it should use this value and

add the product
number in the cell next to it.

What function should I use, or how can I do this?

Thanks,

Roel
.



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
Is This POSSIBLE Rebecca New Users to Excel 8 March 3rd 05 07:05 PM
Cell 255 character limit and formula EaglesNest Excel Worksheet Functions 6 February 27th 05 12:06 AM
SEARCH COPY OF TEXT LinzNac Excel Discussion (Misc queries) 1 February 10th 05 12:39 AM
Relative Macro Help on Keystrokes Neal Zimm Excel Discussion (Misc queries) 9 December 15th 04 12:31 AM
how to copy 2350 hyperlink full paths to any column in a worksheet ? kontiki Excel Discussion (Misc queries) 4 December 10th 04 10:00 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017