how to set formula by locating a row above from a changeable cell

[pigmango]

Hello

in PL!P2, input as SC1, PL!P2 & PL!P3 is set with the formula below which returns details in worksheet inv! depends on PL!P2 and column C and D of invoice page. How to replace the part -4 in PL!PL3 because the -4 is changeable according the position of SC# in worksheet inv

PL!P2 (SC#) is input as SC1
formula in PL!PL2 (SC#) is =OFFSET(INV!$D1,MATCH(P2,INV!$D:$D,0),0)
formula in PL!PL3 (description) is =OFFSET(INV!$D1,MATCH(P2,INV!$D:$D,0)-4,-1)


inv worksheet :
column C contains description details in different rows such as " women's 100% cotton pants " or " men's xxx shorts " etc.
column D contains SC# in different rows such as SC1, SC2

 

[pigmango]

sorry, rev below ...

in PL!P2, input as SC1, PL!P3 & PL!P4 is set with the formula below which returns details in worksheet inv! depends on PL!P2 and column C and D of invoice page. How to replace the part -4 in PL!PL3 because the -4 is changeable according the position of SC# in column D of worksheet inv

PL!P2 (SC#) is input as SC1
formula in PL!PL3 (SC#) is =OFFSET(INV!$D1,MATCH(P2,INV!$D:$D,0),0)
formula in PL!PL4 (description) is =OFFSET(INV!$D1,MATCH(P2,INV!$D:$D,0)-4,-1)


inv worksheet :
column C contains description details in different rows such as " women's 100% cotton pants " or " men's xxx shorts " etc.
column D contains SC# in different rows such as SC1, SC2