Sorry if the title is misleading.
Here is what I intend to convey.
If It is not starting with "29" it should return as 0.Screenshot 2022-03-05 164033.png
Sorry if the title is misleading.
Here is what I intend to convey.
If It is not starting with "29" it should return as 0.Screenshot 2022-03-05 164033.png
Last edited by avinash21; 03-05-2022 at 07:11 AM.
in A14
=IFERROR(INDEX($A$3:$A$9,AGGREGATE(15,6,ROW($A$1:$A$100)/($A$3:$A$9<>""),ROWS($1:1))),"")
in B14
=IF(ISNUMBER(INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1)),"",INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1))
in C14
=INDEX($C$3:$C$10,MATCH(A14,$A$3:$A$10,0))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you sir JohnTopley. I'm grateful to you.
Well, I have started to be familiar about Excel from Mike Garvin Excelisfun YouTube Channel
Sir, one day I would like to learn at least a fraction of what you and Glenn Kennedy know about excel any tips for a novice like me?
Although I'm able apply INDEX, Match and VLOOKUP in isolation, clubbing them & applying seems like a daunting task to me.
Also I didn't understand why have you applied Index formula twice in B14.
Last edited by avinash21; 03-05-2022 at 12:29 PM.
=IF(ISNUMBER(INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1)),"",INDEX($B$3:$B$9,MATCH($A14,$A$3:$A$10,0)+1))[/FORMULA]Formula:Please Login or Register to view this content.
The highlighted part checks if there is a NUMBER (Time) only i.e the TEXT associated with Bill No. in column A is absent: if TRUE, leave cell blank otherwise add the TEXT.
Thank you Mr JohnTopley.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks