Unable to lookup a time value

[iclancy]

Hello,

I am having trouble looking up time values using VLOOKUP. I am attempting to use this formula to look up from the following sheet named "Master Timetable," and return the adjacent value from Column A as a result:
=(VLOOKUP(ROUND($C$6,5),'Master Timetable'!A1:B15,1))

The value C6 in the equation is a predetermined time value that matches one of the values in column B. For example, let's use "5:40 PM." My formula rounds Excel's time value to 5 decimal values (which in this case is 0.73611 in General format), since if I don't round it then the two time values end up not matching and the look up fails. The values in the above table are all rounded to 5 decimal places as well, so the value found in column B8 above also shows up as 0.73611 in General format. So, I'm expecting Excel to be able to find this number using VLOOKUP, but it does not, and returns a "N/A" message or "Value Not Available Error."

Please let me know if I have not provided enough information. Thanks!

 

[Fluff]

Vlookup looks up the value in the 1st column, try

=INDEX('Master Timetable'!A1:A15,MATCH(ROUND($C$6,5),'Master Timetable'!B1:B15,0))

 

[bobsan42]

Vlookup looks in the first column of a range for a match. But afai understand the values you want to match are in the second one B trying to return the value in the first column. so this setup cannot work.
Like Fluff just posted you need index + match

 

[iclancy]

Thanks y'all! Looks like I should have just been using Index instead. Thanks for the help!

 

[Fluff]

Glad we could help & thanks for the feedback.