Look up Function
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
On Jul 24, 4:31*pm, Joanie wrote:
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
|