Help to look the value with various conditions

[Shiradh25]

HI,

I need your support to fix a problem as follows :-

I want to look up the "Marks" by its unique number. But it has some conditions to search.


Please open the excel file attachment. I mentioned all the requirements in it.

Thanks & Regards

Shibin

[mehmetcik]

Put this formula into G3 and fill down

=IF(B3="","",IF(B3=F3,F3,B3+F3))

[Shiradh25]

Thank you for your support.

But one more condition need to be fulfilled in this formula.

The "Sl#" has to be looked up. Because the source of data has many. So "Vlookup" function also to added. I tried, but all in vain.

[jindon]

Perhaps
G3:

=IFERROR(IF(VLOOKUP(E3,$A$3:$B$6,2,FALSE)="","",IF(VLOOKUP(E3,$A$3:$B$6,2,FALSE)=F3,F3,VLOOKUP(E3,$A$3:$B$6,2,FALSE)+F3)),"")