I am trying to run a VLOOKUP with a Concatenate it in that contains an ' and I keep getting #N/A. I have tried other signs/symbols and the vlookup does work so I know it has to do with the apostrophe. I'm using F9 Financial Reporter that is an add-in on Excel and when it pulls info from our Accounting System it puts an ' in front of the account number (ie, '491000). My vlookup formula I am using is =vlookup(Concatenate("'",A8),Input!$E$27:$R$732,4,FALSE) (A8 being 491000). I want to know how I need to re-adjust my formula or if there is another way to go about this.



Thanks