• 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



Participate now!

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