Automation of info

D

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.
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Copy Cell in other sheet 1
VLOOK UP 1
Nested IF conditions 3
Function or Sub to help with text string 5
Lookup Formula 4
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
If and LOOKUP - results in multiple columns 6

Top