# VLOOKUP combine two values into one cell, Name and Surname

#### Nick009

##### New Member
Hello,

I would like to combine the returned values of the following VLOOKUP’s into the same cell

=VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:Order_Data!\$N\$8,2),Supplier_Data!\$A\$2:Supplier_Data!\$L\$100,3)

and

=VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:Order_Data!\$N\$8,2),Supplier_Data!\$A\$2:Supplier_Data!\$L\$100,4)

the last number is the only difference 3 and then 4

Can somebody here help me with this?

They will probably end up being more like this but the simpler version is easier to understand for me.

=IF(VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:Order_Data!\$N\$8,2),Supplier_Data!\$A\$2:Supplier_Data!\$L\$100,3)="","",VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:Order_Data!\$N\$8,2),Supplier_Data!\$A\$2:Supplier_Data!\$L\$100,3))

Many thanks,

Nick

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### ParamRay

##### Well-known Member
.
.

Try something like this:

=TRIM(VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:\$N\$8,2),Supplier_Data!\$A\$2:\$L\$100,3)&" "&VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:\$N\$8,2),Supplier_Data!\$A\$2:\$L\$100,4))

#### Nick009

##### New Member
.
.

Try something like this:

=TRIM(VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:\$N\$8,2),Supplier_Data!\$A\$2:\$L\$100,3)&" "&VLOOKUP(VLOOKUP(\$F\$8,Order_Data!\$A\$2:\$N\$8,2),Supplier_Data!\$A\$2:\$L\$100,4))

That is perfect!! thank you very much.

Replies
1
Views
111
Replies
3
Views
48
Replies
4
Views
190
Replies
6
Views
28
Replies
3
Views
58