Dear all
I want to get search a figure where it meets two conditions of a row and a column. The sample file is attached for easy understanding
thanks in advance for the experts
kindly do the needful
Dear all
I want to get search a figure where it meets two conditions of a row and a column. The sample file is attached for easy understanding
thanks in advance for the experts
kindly do the needful
I'm not sure what you mean by...
There's no match for D2 when searched in column where C2 is satisfied from MASTER!2:2.The value in cell "d2" need to be searched in column where you find (i) above
Also, there are several issues in your sample.
1. You are missing grade values in B2, Q2:T2 range of your sample.
2. You state "either value should be equal or little higher than the value of F2 in the array". However, you give d27 as result for row 3. Which is LOWER than F3.
But if I had to take a guess. You could try...
=MIN(IF(INDEX(MASTER!$B$4:$T$43,,MATCH(C2,MASTER!$B$2:$T$2,0))>=F2,INDEX(MASTER!$B$4:$T$43,,MATCH(C2,MASTER!$B$2:$T$2,0))))
Confirmed as array (CTRL + SHIFT + ENTER).
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Sir , the formula is not working
sorry sir, i have given some wrong cell numbers, i revised the excel sheet and forwarding, please do the needful
Hmm? It's working fine on my end. Did you confirm as array? By pressing CTRL+SHIFT+ENTER before you leave the edit mode in the cell?
See attached.
Thank you very much Sir, Its working Well.Great job you did it sir.
You are welcome. And thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks