Grouping data based on cell input

  • Thread starter Thread starter Matt
  • Start date Start date
M

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!
 
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
 
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
 
Back
Top