Forum Discussion

Copper Contributor

Apr 24, 2020

IF, THEN VLOOKUP Match, Return Cost Item

I have 3 Worksheets: costs input output Goal: On input worksheet, when user selects state they live from drop down list choice, and "Yes" or "No" for each food item from from drop down list ...

excel

Formulas and Functions

wumolad

Iron Contributor

Apr 24, 2020

Hi nciboy

Do you mean something like what I have attached?

Let me know if this is helpful.

Cheers.

IF, THEN VLOOKUP Match, Return Cost Item.xlsx12 KB

nciboy
Copper Contributor
Apr 26, 2020
wumolad

How do I write the formula on the output sheet?
- wumolad
  Iron Contributor
  Apr 26, 2020
  HI nciboy
  
  there are formula in each of the cells in output sheet co!umm B. The formula in cell B2 is
  
  =IF(Input!$B2="Yes",INDEX(Cost,MATCH(Output!$B$1,Cost[State],0),MATCH(Output!$A2,Cost[#Headers],0)),0).
  
  Cheers
  - nciboy
    Copper Contributor
    Apr 27, 2020
    wumolad
    
    my apologies. i realize you the full column name headers were cut off.
    
    Costs