Unit Price Matching Column and Row Codes

[bj90]

Hello,

On my '100' sheet K23:K43 for Unit Price. How can this fill based on Lot Code G14 and description Code B23:B43 and get from the 'Pricing' sheet?

Thank you,
bj

[jeffreybrown]

How about in K23 copied down...

=INDEX(Pricing!$D$5:$H$21,MATCH(B23,Pricing!$C$5:$C$21,0),MATCH($G$14,Pricing!$D$4:$H$4,0))

[bj90]

Thanks that worked but I added error checking:

=IFERROR(INDEX(Pricing!$D$5:$H$21,MATCH(B23,Pricing!$C$5:$C$21,0),MATCH($G$14,Pricing!$D$4:$H$4,0)),"")

[jeffreybrown]

Awesome bj. Thanks for the feedback and you're welcome.