Capture.JPG
Table is in attached picture.
I need formula comparing these to two tables and the functioning as below
A2 <= E3 and B2 = F1 then C2=F3
A values will differ not exactly 2048 & 4096 it may be 2570
i have tried this
=INDEX($E$1:$M$6,IF(A5<=$E$1:$E$6,$E$1:$E$6),MATCH(B5,E$1:M$1,0))
if should be looped until it is true..
The value of A2(=2048) should be compared to E3 to E6. IFA2 is less or equal to E3 (A2 <= E3) then we will consider E3 row .
Plz hlp! Thx in Advance
Bookmarks