fill multi cells with single cell

[mmgta]

Hi, I have a problem. I want to be able to supply multi cells with only fillin
in one single cell. like if i fill in an ID number it will fill in Name
Product amounts. For exampl

Worksheet

ID
Name
A............B............
Product...Amount....Pric
??..........???...........??


Worksheet

A......B.........C............D.............
ID.....Name...Product...Amount....Pric
112...Sony....TV..........200..........800.0

i would like to input the ID number in worksheet one and it auto put in th
Name, Product, amount, and price from worksheet 2

On the second worksheet all the info is on a single row
i was hoping there was a way to link column with cells and fill in based o
using one of them cells in a row.

 

[Gord Dibben]

See Excel help on VLOOKUP function.

Also see Debra Dalgleish's site for more help on VLOOKUP function and Data
Validation dropdown for entering the ID number.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP