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.