Please Help vlookup a CONCATENATE

[jamesnos]

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

[FDibbins]

Hi and welcome to the forum

Concat - as well as left/right/mid - convert numeric to text. try this...=concatenate(A1,A2)*1

[jamesnos]

Thanks so much, that worked a treat.

[FDibbins]

Happy to help, and thanks for the feedback