Further to my previous thread on Aug 2022, I have updated my rolling program a little bit.
Refer to my excel file, sheet "2023-01", in cell F6, I am using IF function for 2 criteria.
Can I add one more criteria to this formula, so that data from column "BY" can be put onto the table ?
In addition to that, I am using vlookup function for column "AN" to "BV", also "BX" and "BY"
Do you think it's better to use Index Match function ?
Thank you for your help.
It is not clear. More explanation of specific requirement and example is required.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Try
Formula:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks