| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automation of info
I have a table with (2) columns. Col. A is id # col. B is billing code. Each
column has about 100 entries. What would like to be able to do is when I type an ID# in let's say column D and have it return the corrosponding billing code in column E. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automation of info
Don,
You can type the following formula in cell E1 =vlookup(d1,a1:b100,2,false) -- http://HelpExcel.com "DonSchreiber" wrote: I have a table with (2) columns. Col. A is id # col. B is billing code. Each column has about 100 entries. What would like to be able to do is when I type an ID# in let's say column D and have it return the corrosponding billing code in column E. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automation of info
Hi,
If the first colum of your table is sorted ascending and your entries will always be in the table, then you can use the short formula: =LOOKUP(D1,A1:B10) If the above conditions won't hold you can use =VLOOKUP(D1,A1:B10,3,) If this helps, please click the Yes button Cheers, Shane Devenshire "DonSchreiber" wrote: I have a table with (2) columns. Col. A is id # col. B is billing code. Each column has about 100 entries. What would like to be able to do is when I type an ID# in let's say column D and have it return the corrosponding billing code in column E. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
| Lookup info in one Column and then returning info in other columns | Excel Worksheet Functions | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Linear Mode
