Vlookup referencing a concatentated cell

[frntrunr2]

=VLOOKUP(F6,AUTHORIZATIONS!A:G,7,FALSE)

AUTHORIZATIONS Table
Column A(9 digit number) = Concatenated cells from column B (contains a 2 digit number) and column C (containing a 7 digit number)

My Vlookup formula is referencing a column (A) which contains concatenated data and it returns a N/A result.

If I replace the concatenated cell by actually typing in the 9 digit number, the formula works fine. Is it possible that Vlookup can't read the contents of A because it just sees the formula and not the resulting number?

I tried using "&" to join the data from the two cells but that didn't help either.

Any suggestions would be greatly appreciated.
Thanks in advance!

 

[sward]

after the concatenate formula put *1 (multiply by 1), this i pressume turns the concatenate answer to a number and will then work -

happens to me all the time!

 

[frntrunr2]

Sure enough! Though the cell still shows the formula, vlookup now understands to return the resulting number. Thanks for your quick (and successful) reply.