VLOOKUP combine two values into one cell, Name and Surname

[Nick009]

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

 

[ParamRay]

.
.

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]

.
.

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.