Hi, I have some problems using the VLOOKUP function. I hope to seek you guys' advice.
So, i used =VLOOKUP(C5,Sheet1!$A$1:Sheet1!$C$15,3) trying to assign a value according to the range table in sheet 1 look like the below table.
Sheet 1 table
Range from to assigned value
1492521300 1492532100 1
1492543800 1492554600 2
1492608600 1492619400 3
1492619400 1492630200 4
1492630200 1492641000 5
1492585980 2
1492586460 2
1492586940 2
But something went wrong with the function that even 1492585980 doesn't fall in any range, it was still being assigned a value of 2.
Anyone know and could tell me how i can resolve this problem?
Thanks,
Yee
Bookmarks