I have the following table:

EMPLOYEE
NUMBER NAME LOCATION JOB TITLE
8178 W AHMED SLADE GREEN PDE
5550 P ALDRIDG RAMSGATE SE2
2744 K ARCHER SLADE GREEN SE2
1900 R ATKINSON RAMSGATE PDE
6285 G ATLEE SLADE GREEN SE2
1914 N ATTWELL RAMSGATE SE1
4986 R AYLING ASHFORD SE3
1550 S BAILEY RAMSGATE HSE Manager
5811 R BALCOMBE RAMSGATE EMS Project Manager
3758 A BALDWIN SLADE GREEN SE1
224 M BANKS RAMSGATE ASE2
382 C BARNES SLADE GREEN SE1

what i want to do is have another table to log errors and rather then input
all details i want the employee to input there id# and all the other data is
populated.

i'm trying to use a VLookup, this is my formula:

=VLOOKUP(F3,B3:E14,2)

F3 is cell id is inputted to, B3:E14 is my data range, and 2 is the 2nd
column of data...i.e. Name

However when i input 8178 the id for

W AHMED,SLADE GREEN,PDE

it actually returns:

C BARNES,SLADE GREEN,SE1

any ideas??

thanks

Hi, You are missing False from your formula .... without this it
automaticallt takes the last record from the table

Try This : =VLOOKUP(F3,B3:E14,2,false)



"Gazz_85" wrote:

I have the following table:

EMPLOYEE
NUMBER NAME LOCATION JOB TITLE
8178 W AHMED SLADE GREEN PDE
5550 P ALDRIDG RAMSGATE SE2
2744 K ARCHER SLADE GREEN SE2
1900 R ATKINSON RAMSGATE PDE
6285 G ATLEE SLADE GREEN SE2
1914 N ATTWELL RAMSGATE SE1
4986 R AYLING ASHFORD SE3
1550 S BAILEY RAMSGATE HSE Manager
5811 R BALCOMBE RAMSGATE EMS Project Manager
3758 A BALDWIN SLADE GREEN SE1
224 M BANKS RAMSGATE ASE2
382 C BARNES SLADE GREEN SE1

what i want to do is have another table to log errors and rather then input
all details i want the employee to input there id# and all the other data is
populated.

i'm trying to use a VLookup, this is my formula:

=VLOOKUP(F3,B3:E14,2)

F3 is cell id is inputted to, B3:E14 is my data range, and 2 is the 2nd
column of data...i.e. Name

However when i input 8178 the id for

W AHMED,SLADE GREEN,PDE

it actually returns:

C BARNES,SLADE GREEN,SE1

any ideas??

thanks

Cheers,

nice one

"Gazz_85" wrote:

I have the following table:

EMPLOYEE
NUMBER NAME LOCATION JOB TITLE
8178 W AHMED SLADE GREEN PDE
5550 P ALDRIDG RAMSGATE SE2
2744 K ARCHER SLADE GREEN SE2
1900 R ATKINSON RAMSGATE PDE
6285 G ATLEE SLADE GREEN SE2
1914 N ATTWELL RAMSGATE SE1
4986 R AYLING ASHFORD SE3
1550 S BAILEY RAMSGATE HSE Manager
5811 R BALCOMBE RAMSGATE EMS Project Manager
3758 A BALDWIN SLADE GREEN SE1
224 M BANKS RAMSGATE ASE2
382 C BARNES SLADE GREEN SE1

what i want to do is have another table to log errors and rather then input
all details i want the employee to input there id# and all the other data is
populated.

i'm trying to use a VLookup, this is my formula:

=VLOOKUP(F3,B3:E14,2)

F3 is cell id is inputted to, B3:E14 is my data range, and 2 is the 2nd
column of data...i.e. Name

However when i input 8178 the id for

W AHMED,SLADE GREEN,PDE

it actually returns:

C BARNES,SLADE GREEN,SE1

any ideas??

thanks