|
VLook Up Error
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 |
VLook Up Error
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 |
VLook Up Error
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 |
| All times are GMT +1. The time now is 08:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com