software

In a tab called WEEKEND I have the following:
cell Q2: LAA
cell R2: 38845-LAA
cell Q4: ATL
cell R4: 38845-ATL

In a tab called LAA:
cell S2: 38810-LAA
cell S3: 38811-LAA
cell S4: 38812-LAA
etc. all the way down to S163

Another tab call ATL has the same type of data as the LAA tab.

I would like a formula in cell S2 in the WEEKEND tab to do the following:
Find the value of cell R2 in column S of the LAA tab and enter Yes if the
corresponding cell in column B in the LAA tab says AWAY. I would then like
to be able to copy this formula into cell S4 to do the same thing but with
the ATL tab.

Let me know if you don't understand what I am asking and I will try and
explain. Thanks in advance.
Look at the INDEX function.

quot;Jambruinsquot; wrote:

gt; In a tab called WEEKEND I have the following:
gt; cell Q2: LAA
gt; cell R2: 38845-LAA
gt; cell Q4: ATL
gt; cell R4: 38845-ATL
gt;
gt; In a tab called LAA:
gt; cell S2: 38810-LAA
gt; cell S3: 38811-LAA
gt; cell S4: 38812-LAA
gt; etc. all the way down to S163
gt;
gt; Another tab call ATL has the same type of data as the LAA tab.
gt;
gt; I would like a formula in cell S2 in the WEEKEND tab to do the following:
gt; Find the value of cell R2 in column S of the LAA tab and enter Yes if the
gt; corresponding cell in column B in the LAA tab says AWAY. I would then like
gt; to be able to copy this formula into cell S4 to do the same thing but with
gt; the ATL tab.
gt;
gt; Let me know if you don't understand what I am asking and I will try and
gt; explain. Thanks in advance.
gt;
gt;

The following formula should work

=IF(INDEX(LAA!$B$2:$B$170,MATCH(R2,LAA!$S$2:$S$170 ,0))=quot;Awayquot;,quot;Yesquot;,quot;Noquot;)--
HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758quot;Jambruinsquot; wrote:

gt; In a tab called WEEKEND I have the following:
gt; cell Q2: LAA
gt; cell R2: 38845-LAA
gt; cell Q4: ATL
gt; cell R4: 38845-ATL
gt;
gt; In a tab called LAA:
gt; cell S2: 38810-LAA
gt; cell S3: 38811-LAA
gt; cell S4: 38812-LAA
gt; etc. all the way down to S163
gt;
gt; Another tab call ATL has the same type of data as the LAA tab.
gt;
gt; I would like a formula in cell S2 in the WEEKEND tab to do the following:
gt; Find the value of cell R2 in column S of the LAA tab and enter Yes if the
gt; corresponding cell in column B in the LAA tab says AWAY. I would then like
gt; to be able to copy this formula into cell S4 to do the same thing but with
gt; the ATL tab.
gt;
gt; Let me know if you don't understand what I am asking and I will try and
gt; explain. Thanks in advance.
gt;
gt;

galimi, that works but I want to be able to copy it down so it works in cell
S4 which would look in the ATL tab. I need the formula to look into the tab
that corresponds with what is in cell Q. Thanks for the help.

quot;galimiquot; wrote:

gt; The following formula should work
gt;
gt; =IF(INDEX(LAA!$B$2:$B$170,MATCH(R2,LAA!$S$2:$S$170 ,0))=quot;Awayquot;,quot;Yesquot;,quot;Noquot;)
gt;
gt;
gt; --
gt; HelpExcel.com
gt; 1-888-INGENIO
gt; 1-888-464-3646
gt; x0197758
gt;
gt;
gt; quot;Jambruinsquot; wrote:
gt;
gt; gt; In a tab called WEEKEND I have the following:
gt; gt; cell Q2: LAA
gt; gt; cell R2: 38845-LAA
gt; gt; cell Q4: ATL
gt; gt; cell R4: 38845-ATL
gt; gt;
gt; gt; In a tab called LAA:
gt; gt; cell S2: 38810-LAA
gt; gt; cell S3: 38811-LAA
gt; gt; cell S4: 38812-LAA
gt; gt; etc. all the way down to S163
gt; gt;
gt; gt; Another tab call ATL has the same type of data as the LAA tab.
gt; gt;
gt; gt; I would like a formula in cell S2 in the WEEKEND tab to do the following:
gt; gt; Find the value of cell R2 in column S of the LAA tab and enter Yes if the
gt; gt; corresponding cell in column B in the LAA tab says AWAY. I would then like
gt; gt; to be able to copy this formula into cell S4 to do the same thing but with
gt; gt; the ATL tab.
gt; gt;
gt; gt; Let me know if you don't understand what I am asking and I will try and
gt; gt; explain. Thanks in advance.
gt; gt;
gt; gt;