hi guys im not sure what i have done wrong but my vlookup function is not working properly
i have attached spreadsheet
in cell L2 i need it to return the correct time by cross referencing cell J2 with the corresponding data on sheet2 in this case Kem 6 which should return this value 1m 11.40s in cell L2
I think you are missing last parameter
try below
=VLOOKUP(J2,Sheet2!$B$1:$C$703,2,0)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
I usually use =VLOOKUP(J2,Sheet2!$B$1:$C$703,2,FALSE) (false for exact matches) but I think Hemesh's observation is exactly what is missing, I added false and it appears to be returning the values you want.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
thank you gentlemen
glad that helped. if your issue is solved don't forget to mark the post as solved AND thanks for the reputation bump, hopefully Hemish got one too since it was his observation I agreed with.
Thanks for considering Sambo
You are welcome swfarm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks