Captain Hindsight
New Member
- Joined
- Oct 9, 2013
- Messages
- 46
I have a tab in Excel in a normal database style.
One of the columns categorises the items.
I then have subsequent tabs - one per category - where I want formulas e.g. a vlookup to extract all the entries in that category from the base sheet.
I can do this with a vlookup or IF function, but:
1. I will constantly be adding rows to the base data so the range will change
2. I do not want any blanks to be on these subsequent tabs
For example, if the range on my base tab is 10 rows from A1 to A10 and A1, A4, A9 all meet category 1 .... in my category 1 tab I want to see the value from A1 in cell A1, the value from A4 in cell A2, the value from A9 in cell A3 etc.
In my sheet this principle is over 100 rows, so I do not want any blank cells or #N/A's inbetween the values I want to see (the ones in the relevant category, in that categories tab).
One of the columns categorises the items.
I then have subsequent tabs - one per category - where I want formulas e.g. a vlookup to extract all the entries in that category from the base sheet.
I can do this with a vlookup or IF function, but:
1. I will constantly be adding rows to the base data so the range will change
2. I do not want any blanks to be on these subsequent tabs
For example, if the range on my base tab is 10 rows from A1 to A10 and A1, A4, A9 all meet category 1 .... in my category 1 tab I want to see the value from A1 in cell A1, the value from A4 in cell A2, the value from A9 in cell A3 etc.
In my sheet this principle is over 100 rows, so I do not want any blank cells or #N/A's inbetween the values I want to see (the ones in the relevant category, in that categories tab).
