Hi guys,

This is my first post and I need your help.

Im trying to vlookup a CONCATENATE number of 2 digits (82) A1= 8 , A2 = 2

The vlookup formula works fine when i type in the number 82 but not when it trys to find it from the CONCATENATE formula.

Please help ...

Ive tried a lot of different ways and can't get it to do what i want(ect A1&A2)

Is there away to do this through excel or VBA

Please provide a step by step instruction