G
Guest
I have a product list within the spreasheet. Product #15-6 (cell A1) costs $5
(cell A2), product #16-9 (cell B1) costs $10 (cell B2), and so on. In
another part of the spreadsheet, when I type 16-9, I want the cell next to it
to automatically enter $10. I would need an elaborate if/then formula. Like
if cell D7=A1, then A2, if D7=B1, then B2, if D7=C1, then C2 and so on for
about 9 items. So whatever item number I type in cell D7, then cell D8 will
automatically place the appropriate price there.
(cell A2), product #16-9 (cell B1) costs $10 (cell B2), and so on. In
another part of the spreadsheet, when I type 16-9, I want the cell next to it
to automatically enter $10. I would need an elaborate if/then formula. Like
if cell D7=A1, then A2, if D7=B1, then B2, if D7=C1, then C2 and so on for
about 9 items. So whatever item number I type in cell D7, then cell D8 will
automatically place the appropriate price there.