Have a challenge that I haven't been able to figure out. My skill with functions is limited so your help would be appreciated.
I have a table with product (A), BASE (B) AND NET (C). I have a lookup table with AREA (H) and PAD (I).
Each of the products start with a two character alpha that matches the items in the area column.
IF LEFT TWO CHARACTERS EQUAL "AREA" THEN MULTIPLY BASE X PAD
I've attached a simple spreadsheet that shows what I need. I think I am experiencing brain fad because this should be simple.