Hello
I was wondering how would i change this formula
Currently it looks to match the Name in B8 to the ones in F:F and return the value in row 3.
I would like it to return if there are more that one answer to return the answer,
currently it returns my answer as 7718 - Student Castle Cambridge if i have 2 different answers can it return it like ? 7718 - Student Castle Cambridge - 7289 - Student Castle London
many thanks Jason
I was wondering how would i change this formula
Currently it looks to match the Name in B8 to the ones in F:F and return the value in row 3.
I would like it to return if there are more that one answer to return the answer,
currently it returns my answer as 7718 - Student Castle Cambridge if i have 2 different answers can it return it like ? 7718 - Student Castle Cambridge - 7289 - Student Castle London
VBA Code:
=IFNA(INDEX(Download!$B$1:$Q$9999,MATCH(B8,Download!$F$1:$F$9999,0),3),"")
many thanks Jason