VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 267
- Office Version
- 365
- Platform
- Windows
- MacOS
hi all,
Need your guidance if possible on how to amend the below array formula to do a lookup all tabs listed below?
=IFERROR(INDEX('4.RANGING CONVENIENCE'!$B:$B,SMALL(IF(B$1='4.RANGING CONVENIENCE'!$A:$A,ROW('4.RANGING CONVENIENCE'!$A:$A)- MIN(ROW('4.RANGING CONVENIENCE'!$A:$A))+1,""), ROW()-2)),"")
Tabs that needs to be lookedup:
<colgroup><col></colgroup><tbody>
</tbody>
I have tried also amending the above formula to a Named Range and removed the ref to a singlular worksheet but it doesnt work.
Any advice and guidance appreciated.
Need your guidance if possible on how to amend the below array formula to do a lookup all tabs listed below?
=IFERROR(INDEX('4.RANGING CONVENIENCE'!$B:$B,SMALL(IF(B$1='4.RANGING CONVENIENCE'!$A:$A,ROW('4.RANGING CONVENIENCE'!$A:$A)- MIN(ROW('4.RANGING CONVENIENCE'!$A:$A))+1,""), ROW()-2)),"")
Tabs that needs to be lookedup:
4.RANGING CONVENIENCE |
5.RANGING FRESH |
6.RANGING GROCERY & HOME |
7.RANGING DRINKS |
8.RANGING BAKERY SNACKING |
<colgroup><col></colgroup><tbody>
</tbody>
I have tried also amending the above formula to a Named Range and removed the ref to a singlular worksheet but it doesnt work.
Any advice and guidance appreciated.