Dec 16 2021 01:05 PM
SO i am so stuck. i have entered this VLOOKUP- VLOOKUP(A2,Sheet1!$A$2:$G$5200,5,FALSE) and nothing populates, whatsoever, I just see the formula in the cell. I don't know what's going on. this is probably so simple and i don't use Vlookup too often, but i feel like this hasn't happened before. If it means anything, i am using employee numbers as the lookup value and just trying to find their service years . I'm going crazy . please help! i need this done by tomorrow and I'm new at work .
Thanks a bunch! :)
Dec 16 2021 02:00 PM
@Detlef Lewin Its on my work laptop containing PII and im not sure if i can share. I know, im not being helpful. :(
Dec 16 2021 02:28 PM
Dec 16 2021 02:41 PM - edited Dec 16 2021 02:42 PM
You wrote: i have entered this VLOOKUP-
VLOOKUP(A2,Sheet1!$A$2:$G$5200,5,FALSE)
And I see two potential issues for starters, above and beyond what @Detlef Lewin has already identified (via Google).
=VLOOKUP(A1,Sheet1!$A$2:$G$5200,5,FALSE)
Note: I've changed your first A2 to read A1, but it should be any other cell reference OTHER THAN a cell within the table itself.
And presuming that column A contains Soc Sec No or an employee ID, whatever the reference value is should be that same type of data.
I've attached an example of VLOOKUP just to illustrate. You can change the value in the cell with the light green background, and there are several VLOOKUPs in the yellow cells that reference the table to the right.
Dec 20 2021 09:41 AM - edited Dec 20 2021 09:44 AM
Thank you very much for this thorough explanation. Unfortunately for some reason i cannot understand this. i am using 2 different workbooks. In my first workbook (WB1) i have employee numbers that i can reference in the first column , to the other workbook(WB2). I am looking to input their years of service from WB2 to WB1. That info is only found on the report on WB2. I'm on the 2nd line in WB1 starting with the first employee (in numerical order in column A)... I am inputting the formula in the service years cell E2. I then go to input the VLOOKUP formula , and i click on A2 which starts the first employee and this formula comes up =VLOOKUP( [@employeeID]], worker details'A$3:F$F5199,6, FALSE) i took out hidden columns, that range is the whole other spreadsheet , without the column titles (e.g. Employee ID, name, etc.) and its still not calculating or bringing the data to the other sheet. I'm so lost. What am i doing wrong? Sorry if it does not make sense. I just can't figure it out!
Thanks for all the help!
Dec 20 2021 10:05 AM
Dec 24 2021 01:47 PM