I want to enter a customer # and retreive their data

[creo]

How do I retreive data, which I've entered, from another worksheet when I
enter a code or # that is specific to that data?

 

[Peo Sjobom]

Assuming you have a yable and the data is set up like

code1 value value etc
code2 value value etc

and so on

then you can use

=VLOOKUP(C1,Sheet2!A2:C50,2,0)

where C1 is the typed in lookup value (code) and A2:C50 the table and this
particular formula will return the value from column 2

lookup VLOOKUP in help


--

Regards,

Peo Sjoblom

Nothwest Excel Solutions

www.nwexcelsolutions.com

remove ^^ from email

"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Max]

How do I retreive data, which I've entered,
from another worksheet when I
enter a code or # that is specific to that data?

Try Debra's pages for 2 ways:

http://www.contextures.com/xlFunctions02.html
(VLOOKUP)

http://www.contextures.com/xlFunctions03.html
(INDEX/MATCH)