Concatenate Values from a Vlookup

[dkim.ags]

Hello,

What I am trying to do is concatenate 2 different values from a vlookup in the macro code instead of having the formulas on the spreadsheet.

For example, cell A1 contains the number 123. If you vlookup 123, column 2 of the range you are looking up contains "Car" and column 3 contains "Part".

Therefore, I would want cell B2 to display "Car Part".

I thought something like FormulaR1C1 = "=VLOOKUP(A1, Range, 2, 0)"&"=VLOOKUP(A1, Range, 3, 0)" would work.

Any have an idea on how to do this?

Thank you!

[Mayda89]

Maybe if you remove the second equal sign it may work; i.e

Please Login or Register  to view this content.

Note that I used formula instead of formular1c1; this is because you used A1 style referencing in your code.

[dkim.ags]

Other than the removal of the R1C1, I don't see a difference, unless I'm not seeing something.

[Mayda89]

You're right, I forgot to make the adjustment that I wrote

The code should be like this I suppose:

Please Login or Register  to view this content.

Hope it helps,
Cheers