VLOOKUP combine two values into one cell, Name and Surname

Nick009

New Member
Joined
Sep 23, 2014
Messages
2
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
 

Some videos you may like

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
Joined
Aug 6, 2014
Messages
1,195
.
.

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
Joined
Sep 23, 2014
Messages
2
.
.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,204
Messages
5,527,410
Members
409,760
Latest member
zeeshansyed

This Week's Hot Topics

Top