Hi All,
Any help with be greatly appreciated...........
Very difficult one to explain so I have attached an example spreadsheet, with the required formulae to be inputted into the highlighted range which currently shows my expected results.
Hi All,
Any help with be greatly appreciated...........
Very difficult one to explain so I have attached an example spreadsheet, with the required formulae to be inputted into the highlighted range which currently shows my expected results.
Whats the logic that would make you decide Type 1 2 3 or 4?
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Using Asset 1 as an example:
G14 shows the MIN date in range C14:F14
G5 then looks up this MIN date result for Asset 1
I then need C5 to return the relevant result from C12:F12 based on the MIN date for Asset 1 (in this case looking at C14:F14)
Hope this makes sense
try this formula and drag down
=INDEX($C$12:$F$12,,MATCH($G5,INDIRECT("C"&MATCH($B5,$B$14:$B$17,0)+13&":F"&MATCH($B5,$B$14:$B$17,0)+13),0))
If your data is different than your example you may need to change the references as well as the RED 13. The 13 is signaling that your data lookup is starting on row 14. So adjust carefully.
It worked perfectly, and if I could kiss you I would......... thank you so much
100% reputation deserved
My wife would would not be fond of that response LOL, and thanks for the Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks