I am unable to fix the formatting of my lookup array. I am using a left function to get four digits of a reference . if I manually type the number then the vlook up works but if I use it with left function then it does not work. Please advise
If I can recommend you, add a file (without sensitive data) and explain your plan by adding something to your question in the file. This means that you can be helped faster and more accurately and it is made easier for the helpers to offer you a tailor-made solution. So you can only guess and guessing was never good.