Forum Discussion
EXCEL HELP - VLookup and Hlookup combination
Sorry, possibly a straightforward answer no doubt, not for me as a newby... Refer to the attached Workbook. Two worksheets 1. Pricelist; This is where line items (products) are collated along ...
In G2:
=IFERROR(INDEX(PRICELIST!$D$3:$F$5,MATCH(C2,PRICELIST!$A$3:$A$5,0),MATCH(B2,PRICELIST!$D$2:$F$2)),"")
Fill down.