Look up Function
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 |
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 |
All times are GMT +1. The time now is 09:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com