Replacing Data
 

HEEELP! My boss has a worksheet with items and amounts of such. He wants to
be able to type up an item number and an amount for that item to
automatically appear in the amount slot...is this possible? and if so how do
you do it. Please help me!

eg:

Item Amount
123 200
124 450
125 300
(123) (200)

Replacing Data
 

hi,

assuming the data is on a2:b100 and he will put the code on h1 to excel
return the amount on i1

on i1 use

=vlookup(h1,$a$2:$b$100,2,false)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Grifito" escreveu:

HEEELP! My boss has a worksheet with items and amounts of such. He wants to
be able to type up an item number and an amount for that item to
automatically appear in the amount slot...is this possible? and if so how do
you do it. Please help me!

eg:

Item Amount
123 200
124 450
125 300
(123) (200)