Hi I’m looking for some help with a sheet I am creating.
The sheet has two drop down boxes (cells B&C) Thea draw information from another sheet in the work book to effectively give me just one line on the front sheet.
What I am struggling with is getting cell I to look at both cell B & C and if specific text matches then cell I would take information from the other work sheet.
In the pic b4= “c65” and c4= “4” so i4 sould pick up the 29.25 on the info sheet cell H4
If anyone could help I’d much appreciate it.
Also have to replicate this fore all three scenarios (1n2, 3 &4) for each of the products. What is the best way to replicate the formula (if possible) thanks.
The sheet has two drop down boxes (cells B&C) Thea draw information from another sheet in the work book to effectively give me just one line on the front sheet.
What I am struggling with is getting cell I to look at both cell B & C and if specific text matches then cell I would take information from the other work sheet.
In the pic b4= “c65” and c4= “4” so i4 sould pick up the 29.25 on the info sheet cell H4
If anyone could help I’d much appreciate it.
Also have to replicate this fore all three scenarios (1n2, 3 &4) for each of the products. What is the best way to replicate the formula (if possible) thanks.