Hi, I am having trouble with index and match. i have one colume for index B but need to match over a number of different colums J to U.
i have goten this far and i tryed many different variations
currently
=INDEX(B2:B40,(MATCH(E1,J2:J46,(MATCH(E1,K2:K46,0)))))
this retuns the correct index but seem to jump over J
=INDEX(B2:B40,(MATCH(E1,J2:J46,0)))
works but i need to sherch over colunms J to U
please help
Solved by K. Y. in 22 mins