Hi,

Can anyone help again.

I have set up a spreadsheet with Match and Index to lookup account
numbers, some are just normal numbers and other a prefixed with a
letter before the.

i.e. 10001230 or E10011

match and index doesn't recognise account numbers a that are true
numbers, only the one that start with a letter, i have been using the
below formula, can anyone help?

=INDEX(Account!$A$1:$B$2035,MATCH($A5,Account!$A$1 :$A$2035,0),2)

Regards

Linexe