VLOOKUP Error

  • Hi Folks


    I'm hoping someone can guide me as to where I'm going wrong with a VLOOKUP formula please?


    The lookup looks at a name in a column, compares it to a name in another column on a different sheet to look for the matching name and then returns a table number for that person.


    The formula I'm using is: =VLOOKUP(C7,Sheet1!D2:D5,2,0) (see attached sample book) but I keep getting a #REF! error. On the working book the name in C7 is picked up from another sheet using a formula, (not sure if it is this that is causing the error??) I've replicated this on the sample book as well.


    Any help much appreciated as usual, I know it's going to be something I've missed.. :(


    Kind regards


    DezB


    [ATTACH]n1198993[/ATTACH]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!