I'm trying to create a nutritional information tool using excel and am hoping someone can help me out with a formula that I can't seem to get right.
On one page I have two drop down menus, one relating to activity and one relating to goals.
The activity dropdown has five options 'Sedentary', 'Light', 'Moderate', 'Heavy' and 'Extra' and is linked to a table, which includes a calorific value, and the goal dropdown has two values 'Fat Loss' and 'Weight Gain'.
What I am attempting to do is have a cell that combines these two options in order to provide a target for the user (which updates depending on which values are selected from the dropdown).
So far my formula reads =IF(B2="Fat Loss", [=VLOOKUP(B1,TDEEValue,2,FALSE)-500], [=VLOOKUP(B1,TDEEValue,2,FALSE)+500])
Where B2 is the dropdown menu with 'Fat Loss' and 'Weight Gain' as options, and B1 is the activity dropdown, linked to my table named TDEEValue (the calorific values attached are in column 2).
I've tested the VLOOKUP function in isolation and that works fine, so the problem is obviously with the if part of my formula, I'm currently getting a 'The name that you entered is not valid' error.
Can anyone help, or have I gone about the whole thing the wrong way?
Thanks
Bookmarks