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..