Hi All,
I just have a little problem, ive attached an example, what I'm trying to do is take the date in A1 and find the nearest date to that date which was before A1 happneded and for it to return the T number.
I hope I have explained this properly and the attached clears up anything Ive missed.
Thanks
Try this formula in A3
Format as Date
=LOOKUP(A2,B2:H2,B2:H2)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Is it possible to arrange the date/times in row 2 to be in chronological order?
Pete
Try in H2:
=LOOKUP(2,1/(MIN(ABS(A2-B2:G2))=ABS(A2-B2:G2)),B$1:G$1)
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Quang PT
Sorry, should've read the requirements more carefully.
=INDEX(B1:G1,MAX(INDEX((B2:G2<A2)*(COLUMN(B2:G2)-1),0)))
Or this one
=INDEX(B1:G1,,MATCH(A2,B2:G2,1))
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks