Combine two Vlookups in one cell

[DougStroud]

I need to locate two values and combine them in the same cell and add a text value.

The final result would look like this: $3000/$6000.
=VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,5, FALSE) & =VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,6, FALSE)

I have tried a few different approaches but failed. I need some assistance with this please.

=VLOOKUP(($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,5, FALSE, VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,6, FALSE))

Thanks.

 

[eduzs]

Why not "=1st vlookup & "/" & 2nd vlookup ??

=VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,5, FALSE) & "/" & VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,6, FALSE)

 

[Patropi]

Try it this way:

= VLOOKUP ($ D $ 6, 'Carteira 2019.csv'! $ D $ 4: $ AE $ 116,5, FALSO)&VLOOKUP ($ D $ 6,'Carteira 2019.csv'! $ D $ 4: $ AE $ 116,6, FALSE)

 

[DougStroud]

Try it this way:

= VLOOKUP ($ D $ 6, 'Carteira 2019.csv'! $ D $ 4: $ AE $ 116,5, FALSO)&VLOOKUP ($ D $ 6,'Carteira 2019.csv'! $ D $ 4: $ AE $ 116,6, FALSE)

Thank you eduzs! I was on that path, but I was trying to nest them... Thank you!!!

 

[DougStroud]

Try it this way:

= VLOOKUP ($ D $ 6, 'Carteira 2019.csv'! $ D $ 4: $ AE $ 116,5, FALSO)&VLOOKUP ($ D $ 6,'Carteira 2019.csv'! $ D $ 4: $ AE $ 116,6, FALSE)

Thank you Patropi, you were on the same direction as eduzs.