Hi all,
I am trying to use a vlookup that references a singular text value that is selected by an autofilter.
Is there any way of getting the Subtotal function return a single text result? I know this works for numbers, so the formula below returns 0.
=SUBTOTAL(9,A2:A5)
If not, is there any method of returning a single text value from a list after autofilter has been applied?
Example data -
A1 - Test1 (result of A2, when A2 filtered)
A2 - Test1
A3 - Test2
A4 - Test2
A5 - Test3
I am trying to use a vlookup that references a singular text value that is selected by an autofilter.
Is there any way of getting the Subtotal function return a single text result? I know this works for numbers, so the formula below returns 0.
=SUBTOTAL(9,A2:A5)
If not, is there any method of returning a single text value from a list after autofilter has been applied?
Example data -
A1 - Test1 (result of A2, when A2 filtered)
A2 - Test1
A3 - Test2
A4 - Test2
A5 - Test3