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

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