Hi, I'm trying to do a vlookup but using names instead of numbers, first time using names, I've followed others examples, but still getting a #N/A return.
My formula is: =VLOOKUP(F2&G2,A2:C968,3,FALSE) where F= first name, G=surname, A= first name(lookup), B=surname (lookup), C=employee number (return).
I have also tried adding, as one post suggested, a concatenate column of columns A&B, but this does still not work.
Can anyone help me with what I am doing wrong?
Thanks in advance.
My formula is: =VLOOKUP(F2&G2,A2:C968,3,FALSE) where F= first name, G=surname, A= first name(lookup), B=surname (lookup), C=employee number (return).
I have also tried adding, as one post suggested, a concatenate column of columns A&B, but this does still not work.
Can anyone help me with what I am doing wrong?
Thanks in advance.