Forum Discussion

Copper Contributor

Aug 08, 2019

Solved

Which formula to create?

I am working on a spreadsheet. On the first worksheet of my workbook, I have a table with each person and their respective information (age, their choice of A or B, ect.). In my data tab, I have ...

excel

Formulas and Functions

training

PReagan
Aug 08, 2019
Hello Chels405,

In cell E2, that could be something like:

=if(C2="A",VLOOKUP(D2,'Data'!$A$3:$C$22,2,false),IF(C2="B",VLOOKUP(D2,'Data'!$A$3:$C$22,3,false),"No Result")

Chels405

Copper Contributor

Aug 08, 2019

PReagan

Not a problem!

So under my Master tab, I would like the amount to show up in the highlighted area under Cost (Column E) from my Data tab, but the determining factors of the cost is dependent on Choice A or B and the age of the individual:

PReagan

Bronze Contributor

Aug 08, 2019

Hello Chels405,

In cell E2, that could be something like:

=if(C2="A",VLOOKUP(D2,'Data'!$A$3:$C$22,2,false),IF(C2="B",VLOOKUP(D2,'Data'!$A$3:$C$22,3,false),"No Result")

Chels405
Copper Contributor
Aug 08, 2019
PReagan

Thank you! I will try it out!