Doing a Lookup for Last Number or Last Text in a List
Here is how you can look up items in one column, based on the last cell in a different column of that list which contains a number or text.
The formula in cell E2 is
It returns “Black Onyx” because that is what is in cell C15, corresponding to the fact that cell A15 contains the last number (a time, but still a number) in column A of that list.
=INDEX(A3:C17,MATCH(9.99999999999999E+307,A3:A17,1),3).It returns “Black Onyx” because that is what is in cell C15, corresponding to the fact that cell A15 contains the last number (a time, but still a number) in column A of that list.
The formula in cell F2 is
It returns “4:04” because that is what is in cell D14, corresponding to the fact that cell A14 contains the last text item in column A.
#evba #etipfree #kingexcel=INDEX(A3:D14,MATCH(REPT("z",255),A3:A14,1),4).It returns “4:04” because that is what is in cell D14, corresponding to the fact that cell A14 contains the last text item in column A.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
Hi, I'm Mr KING Admin of KINGEXCEL.INFO .Thank you so much and I hope you will have an interesting time with KINGEXCEL.INFO. Mail: quantriexcel@gmail.com - PHONE : +84779313987.