Look up Function

  • Thread starter Thread starter Joanie
  • Start date Start date
J

Joanie

I want to be able to enter a number and have the information that corresponds
to that number (ie, description of service, amount, etc.) in a list,
automatically fill in the row. I knew how to do this years ago, but forgot!
if you have a quickie sample i would really appreciate it. thanks, joanie
 
You would normally use VLOOKUP to do this, getting corresponding data
from a table which matches the first column of the table. If the table
is on Sheet1 occupying A1 to E100, say, and you enter a number into A1
of Sheet2, then you can put this formula in B1 of Sheet2:

=VLOOKUP($A1,Sheet1!$A$1:$E$100,COLUMN(B1),0)

Then you can copy the formula into C1:E1 to pick up items from those
columns.

Hope this helps.

Pete
 
Back
Top