I have time values in column B, prices in column C.
I want to place whatever price showing in cloumn C at 7am into cell G3.
What function do I need to use to accomplish this?
I have time values in column B, prices in column C.
I want to place whatever price showing in cloumn C at 7am into cell G3.
What function do I need to use to accomplish this?
Last edited by novice2430; 11-02-2008 at 07:00 PM.
Assuming the times in column B have times only (no dates), and that there is an exact match, you could use
=VLOOKUP("7:00"+0, B1:C10, 2, FALSE)
If the times are in ascending order and you want the latest time not past 7AM,
=VLOOKUP("7:00"+0, B1:C10, 2)
Entia non sunt multiplicanda sine necessitate
That will work! Thanks again shg!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks