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.

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.

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.