Automation of info

[DonSchreiber]

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.

 

[galimi]

Don,

You can type the following formula in cell E1

=vlookup(d1,a1:b100,2,false)

 

[Shane Devenshire]

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