Dear Forum members
I'm a new user of the excelforum and I would like to ask for your help with an excel-formula. I guess the easiest way to explain my problem is to work with an example (see TEST worksheet in attachment).
I would like to search for a value (in column B) within column H and I. If (B_rowA > H_rowX) and (B_rowA < I_rowX) AND A_rowA=G_rowX then give value F_rowX.
So in the case of B3=6957771 it should return 01g015090 (as 6956388 (=H1458) <6957771<6963140 (=I1458) AND A3 (place_1)=G1458 (place_1)).
So in the case of B30=883152 it should return 15g01990 (as 883111 (=H11536) <883152< 889020 (=I11536) AND A30 (place_15)=G11536 (place_15)).
I already made an attempt (FORMULA-column), but till now the formula didn't work well because I cannot incorporate the condition of A_rowA=G_rowX)
Any help is welcome!
Kind regards
Wannes
Bookmarks