Just Anonymous User
New Member
- Joined
- Sep 24, 2018
- Messages
- 4
How do I reference another worksheet that has information listed, but skip any blank cells without using VBA?
I tried using the formula from another thread:
{=IFERROR(INDEX(Sheet1!$A$2:$A$22,SMALL(ISTEXT(Sheet1!A2:A22),ROW(Sheet1!$A$2:$A$22)),ROWS(A$31:A31))-ROW($A$31)+1,"")}
but I am still just getting an empty cell, instead of getting the next available cell with information in it.
Thanks,
I tried using the formula from another thread:
{=IFERROR(INDEX(Sheet1!$A$2:$A$22,SMALL(ISTEXT(Sheet1!A2:A22),ROW(Sheet1!$A$2:$A$22)),ROWS(A$31:A31))-ROW($A$31)+1,"")}
but I am still just getting an empty cell, instead of getting the next available cell with information in it.
Thanks,