Forum Discussion
brenden1973
Aug 20, 2021Copper Contributor
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 ...
HansVogelaar
Aug 20, 2021MVP
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.