Match returns #N/A

[geofspa]

Good Morning

I wonder if anyone could help me - I have a problem using Match.

I have a database extract where by account number and account name are concatenated on the extracted report - this is OK because the account number is always 7 characters(always numerical) long and to the left - so I have a helper column that holds the formula =left([@Account],7) which gives me the account number split out.

On another sheet I need to "Lookup" this account number - but using Match function only returns #N/A unless I copy / Paste account number as text and then change Text to Columns

Is there any way around having to complete this copy / Paste / Text To Columns routine ... and then having to rewrite formulae with the next extract ?

Thanks
Geof

PS same is true for Vlookup ... not that it surprises me

Thanks

 

[geofspa]

I have found it --- change the lookup column to text -- all works then

Can anyone remove this post ?

 

[footoo]

Or change the formula to : =--LEFT([@Account],7)