excel match value(get row) in two-dimensional array -

excel match value(get row) in two-dimensional array -

i have next construction in excel sheet.

e f g h --------- --------- ------ ------- 2 | blah sometext atext smth 3 | textval accc 4 | test avfr 5 | check 6 | ertyui 7 |

can suggest way using excel functions (not vba) of getting row of matching string?

for example: given test need 4, given ertyui 6

i need:

the lookup done in columns of two-dimensional array and

have function in 1 cell

with search string in a1:

=sumproduct((e2:h6=a1)*row(e2:h6))

obviously fail if there more one occurrence of search string within range. however, each of values in dataset provide unique, presume not issue.

besides, if was possibility, need clarify of potentially several different row numbers should preferred return.

regards

arrays excel multidimensional-array excel-formula