Grouping data based on cell input

[Matt]

I enter logs for orders invoiced in a day, and I'm trying
to figure out a way to enter the Acct# in cell A1 and have
cells B1 & C1 (which will be the Rel# and Cust Name) fill
in automatically.

If this is unclear please let me know, I need help!

 

[Tim Otero]

If you have a listing of your accounts, including Acct#, Rel#, and Cust
Name, you could use VLOOKUP. Excel help is pretty good for VLOOKUP. If you
need more help constructing it, please post back with more specific
information.

tim

 

[Paul Corrado]

Matt,

Assuming that every Acct# is uniquely associated with every Rel# and Cust
Name, you can use VLOOKUP to return that information from a table that
contains that information.

So, if the table has Acct#, Rel#, Cust Name in three consecutive columns
then

=VLOOKUP("acct#","table range",2,False) would return the Rel# and
=VLOOKUP("acct#","table range",3,False) would return the Cust Name.

HTH

PC