Forum Discussion

Chels405's avatar
Chels405
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's avatar
    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")

JLEthridge's avatar
JLEthridge
Copper Contributor
Aug 08, 2019

Chels405 I've attached a spreadsheet that has a "shortcut" of sorts in it. You'll want to spot check it but this would be a slightly quicker route. Rather than explain it all out, I just created a spreadsheet and showed the formulas next to each of the cells so you can see what I did. Hope it helps.