View original (French)

Put 2 vlookups in the same cell

electsteph Posted messages 7 Status Member -  
electsteph Posted messages 7 Status Member -
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.

2 answers

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    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
    7