Vlookup: 3 columns to 1

  • Thread starter Thread starter natei6
  • Start date Start date
N

natei6

Hello,

=IF($C$8<>"",VLOOKUP($C$8,Invoice.xls!Cust_List,2,0),"")

I have this formula in C10. It gives me the corresponding data fro
column 2, but I would like it to give me the data from columns 2,3, an
4. Example (Portland OR 97123). I have tried
=IF($C$8<>"",VLOOKUP($C$8,Invoice.xls!Cust_List,2 & 3 & 4,0),"") bu
no luck. Your help is appreciated

Nathan Sargean
 
Hi

=IF($C$8<>"",VLOOKUP($C$8,Invoice.xls!Cust_List,2,0) & " " &
VLOOKUP($C$8,Invoice.xls!Cust_List,3,0) & " " &
VLOOKUP($C$8,Invoice.xls!Cust_List,4,0),"")
 
Nate,
Try

=IF($C$8<>"",VLOOKUP($C$8,Invoice.xls!Cust_List,2,0)&
VLOOKUP($C$8,Invoice.xls!Cust_List,3,0)&VLOOKUP($C$8,Invoice.xls!Cust_List,4,0),"")

HTH
rick
 
Back
Top