Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |