Lets say I have a worksheet consisting of 3 columns and 3 rows
row a1=NY row a2 =Tex row a3 =Tex
row b1=1 row b2=2 row b3 =3
row c1=Tex c2=Fla row c3= NY
my question is I would like to use a vlookup or match or an idex formula in D1 to return multiple values
if I use...