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...