Replacing Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top