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")

PReagan

Bronze Contributor

Aug 08, 2019

Hello Chels405,

Would you mind setting up a sample worksheet to illustrate what you are describing? This will help me better answer your question.

Thank you!
PReagan

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!