Register now or log in to join your professional community.
first your question need more explain
any way there are many formula we can use to match data
*
if your array (A1:E1) and cell A1 contain unique value and you want the informations in cell "B1" OR "C1" OR" D1" OR" E1" whatever
to getting particular information matching with the unique value
put these same unique value in cell A3
select cell B3 and put these formula
=INDEX(A1:F1;MATCH(A3;A1:F1;0);2)
you will get in formation in cell B1
or this formula
=VLOOKUP(A3;A1:F1;2;0)
**** notes
A3 = LOOK UP VALUE "CRITERIA "" " THE UNIQUE VALUE " IN CELL A1 "
"A1:E1" the array of data
2 =" the column number " if you need information in cell "B1"
3= " the column number" if you need information in cell "C1"
4=" the column number" if you need information in cell "D1"
5 =" the column number" if you need information in cell "E1