Table lookup & return of concatenated string from Row

[jdfjab]

What would be the VBA syntax to find a “key” in table column “A” and return a concatenated string : (“ColumnA” & “ColumnD” & “ColumnB”) from the row the key is found in?

[royUK]

I think you probably need to combine 3 vlookups in the result cell

[jdfjab]

Can you give me an example of the syntax to use vlookup in Vba?

Thx

[royUK]

Why do you need VBA for this? What are you doing exactly?

[jdfjab]

I need to duplicate an existing pricing matrix printout (See Worksheet("Printout to Duplicate")
I have the code written to Get the pricing "records" see worksheet("PrcType"), but the report is a Concatenation of values from worksheet("master'), not the price record itself.

Please Login or Register  to view this content.

[jdfjab]

Got it, thanks.
I used:

Please Login or Register  to view this content.