HI Everyone,

I posted this question in the other forum for Excel but no response so far hence I am posting it here.
--------------------------------------------

Is there a way to execute the result of =concatenate formula.

I have following formula =(CONCATENATE(B2,B15,B11,B3,B4))

That results in cell b19 as ... VLOOKUP($h$10,'[Client Outstanding Status-2012.xls]Salvage Outstanding'!C1056:$P$3000,2,FALSE)

I would like to execute this in cell b20 as a vlookup formula.

Is there a way to do it without going into VBA?

Thanks
Naeem