Put 2 vlookups in the same cell
electsteph
Posted messages
7
Status
Membre
-
electsteph Posted messages 7 Status Membre -
electsteph Posted messages 7 Status Membre -
Hello,
I would like to know if it is possible to put 2 VLOOKUP functions in the same cell.
Here is the example;
=VLOOKUP(H3, clientTable, 4, 0) but I would like to also include column 5.
Is that possible?
Thank you in advance.
I would like to know if it is possible to put 2 VLOOKUP functions in the same cell.
Here is the example;
=VLOOKUP(H3, clientTable, 4, 0) but I would like to also include column 5.
Is that possible?
Thank you in advance.
2 réponses
Hello
The VLOOKUP function is performed on the first column of the client table and returns the corresponding value from column 4
If you want to have the values from columns 4 and 5 in the same cell, you need to concatenate 2 VLOOKUPs (results separated by a space with the " "):
=VLOOKUP(H3;clientTable;4;0) & " " & VLOOKUP(H3;clientTable;5;0)
Best regards
--
"Imagination is more important than knowledge." A. Einstein
The VLOOKUP function is performed on the first column of the client table and returns the corresponding value from column 4
If you want to have the values from columns 4 and 5 in the same cell, you need to concatenate 2 VLOOKUPs (results separated by a space with the " "):
=VLOOKUP(H3;clientTable;4;0) & " " & VLOOKUP(H3;clientTable;5;0)
Best regards
--
"Imagination is more important than knowledge." A. Einstein