Generating customer names in B by entering acct# in A

B

budmck

How can I produce a customer name in column B by entering the accoun
number in Column A? VLOOKUP? How, please?
budmc
 
R

Rojee

Vlookup will work..

=vlookup(Lookup_value,Table_Array,Col_index_num,Range
lookup)

Ex. Table Array or Data base is on Sheet2 A1:K200
=vlookup(A1,sheet2!$A$1:$K$200,2,false)
 
J

JulieD

Hi

if you have a list somewhere else in the workbook of Account Numbers and
Customer Names you can use VLOOKUP to do it. Say this list is on sheet2
range - A2:B100
and you want to enter the account number in sheet 1 A2 and have the customer
name appear in B2

in sheet 1 B2 type
=VLOOKUP(A2,Sheet2!$A$2:$B$100,2,0)
which means, lookup the value in A2, in the table on sheet2 and return the
information in the 2nd column where there is an exact match.

However, if A2 doesn't have anything in it you will get a #NA error, so to
"supress" this edit your formula to read
=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$B$100,2,0)),"",VLOOKUP(A2,Sheet2!$A$2:$B$10
0,2,0))

Hope this helps
Cheers
JulieD
 
Top