Forum Discussion
Help with excel if
Hi, I'm trying to write a formula so that IF D5 = "Yes" AND D3 = "Data Collection" then to do VLOOKUP within a different tab named Data Collection. However I'd like this same formula to do a diff...
=IF(AND(D5="Yes",D3="Data Collection"),
VLOOKUP(D4,'Data Collection codebook'!B3:F165,5,FALSE),
IF(AND(D5="Yes",D3="MRA."),
VLOOKUP(D4,MRA.!B3:F165,5,FALSE),""))
Maybe like this.
=IF(AND(D5="Yes",D3="Data Collection"),
VLOOKUP(D4,'Data Collection codebook'!B3:F165,5,FALSE),
IF(AND(D5="Yes",D3="MRA."),
VLOOKUP(D4,MRA.!B3:F165,5,FALSE),""))
Maybe like this.
Thank you!
