Forum Discussion
Solved
Formula for multiple outcomes
Iv a spread sheet that changes daily. If things stayed in one place I can work it but as they don't I'm looking for a formula that can take in different possibilities.. today FSG (full size glass) wou...
Maybe as in the attached file.
In square M5 I want to put a formula in it to show what I’m short to fill out my order. I can do the formula that will subtract what I have in stock and what I need but what I want to have in place is a formula that can look down column B and see FSG then match it with column F and give me what I need to order. My problem is. This table can change regularly so we’re FSG is now might not be SSG tomorrow. Is their a formula that can pick up FSG or SSG then find my total. Think what I’m looking for is something like.. IF FSG is in B5 and Full Size Glass is in C5 then show figures from F5. But what if FSG is in B8 and Full Size Glass is in F8 then F5 figures will not be what I need. I will need figures from F8.. so I need a formula to match FSG and Full Size Glass and its quantity needed. Bow is a small copy of what table I'm using.
Maybe as in the attached file.
- Great reply. I'll give it a good look and see how it works but so far looks great thank you.