anthonyexcel
Active Member
- Joined
- Jun 10, 2011
- Messages
- 258
- Office Version
- 365
- Platform
- Windows
The Data that I have on sheet one needs to bring back data from sheet 2 based on ID Number and day (which will bring back the school associated with the ID and Day. Thanks in advance Anthony.
******** ******************** ************************************************************************><CENTER>
<TBODY>
</TBODY>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
This is what I have on sheet2
******** ******************** ************************************************************************><CENTER>
<TBODY>
</TBODY>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
This is what I would like the output to look like:
******** ******************** ************************************************************************><CENTER>
<TBODY>
</TBODY>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
******** ******************** ************************************************************************><CENTER>
<TBODY> </TBODY> | |||||||
<TBODY> </TBODY> | |||||||
<TBODY> <FORM name=formFb078704> </FORM> </TBODY> | |||||||
<CENTER>A</CENTER> | <CENTER>B</CENTER> | <CENTER>C</CENTER> | <CENTER>D</CENTER> | ||||
<CENTER>1</CENTER> | ID_Number | Days | |||||
<CENTER>2</CENTER> | 227 | Thu | |||||
<CENTER>3</CENTER> | 227 | Tue | |||||
<CENTER>4</CENTER> | 233 | Fri | |||||
<CENTER>5</CENTER> | 3261 | Tue | |||||
<CENTER>6</CENTER> | 3261 | Wed | |||||
<CENTER>7</CENTER> | 3261 | Thu | |||||
<CENTER>8</CENTER> | 103 | Fri, Mon | |||||
<CENTER>9</CENTER> | 103 | Tue | |||||
<CENTER>10</CENTER> | 103 | Wed, Thu, Fri, Tue, Wed | |||||
<CENTER>11</CENTER> | 103 | Thu | |||||
<CENTER>12</CENTER> | 103 | Fri, Mon, Tue, Wed, Thu, Fri | |||||
<CENTER>13</CENTER> | 103 | Mon, Tue, Wed | |||||
<CENTER>14</CENTER> | 303 | Fri | |||||
<CENTER>15</CENTER> | 303 | Fri, Mon, Tue, Wed | |||||
<CENTER>16</CENTER> | 303 | Fri | |||||
<CENTER>17</CENTER> | 303 | Mon | |||||
<TBODY> </TBODY> |
<TBODY>
</TBODY>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
This is what I have on sheet2
******** ******************** ************************************************************************><CENTER>
<TBODY> </TBODY> | |||||||||
<TBODY> </TBODY> | |||||||||
<TBODY> <FORM name=formFb202339> </FORM> </TBODY> | |||||||||
<CENTER>A</CENTER> | <CENTER>B</CENTER> | <CENTER>C</CENTER> | <CENTER>D</CENTER> | <CENTER>E</CENTER> | <CENTER>F</CENTER> | ||||
<CENTER>1</CENTER> | ID | Mon | Tue | Wed | Thu | Fri | |||
<CENTER>2</CENTER> | 227 | Johnson | Johnson | Johnson | Johnson | Johnson | |||
<CENTER>3</CENTER> | 233 | Roosevelt, Washington | Roosevelt, Washington | Lincoln, Washington, Tyler | Lincoln, Washington | Roosevelt, Washington | |||
<CENTER>4</CENTER> | 3261 | Kennedy | Coolidge | Coolidge | Kennedy | Kennedy | |||
<CENTER>5</CENTER> | 257 | Barnum | Barnum | Barnum | Barnum | ||||
<CENTER>6</CENTER> | 2135 | Madison | Madison | Monroe, Madison | Madison | ||||
<CENTER>7</CENTER> | 103 | Harrison, Taylor | Tyler, Fillmore | Madison, McKinley, Wilson | Madison, McKinley, Wilson | Garfield | |||
<CENTER>8</CENTER> | 303 | Harding | Harding | Harding | Harding | Harding | |||
<TBODY> </TBODY> |
<TBODY>
</TBODY>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
This is what I would like the output to look like:
******** ******************** ************************************************************************><CENTER>
<TBODY> </TBODY> | |||||||
<TBODY> </TBODY> | |||||||
<TBODY> <FORM name=formFb543420> </FORM> </TBODY> | |||||||
<CENTER>A</CENTER> | <CENTER>B</CENTER> | <CENTER>C</CENTER> | <CENTER>D</CENTER> | ||||
<CENTER>1</CENTER> | ID_Number | Days | |||||
<CENTER>2</CENTER> | 227 | Thu | Johnson | ||||
<CENTER>3</CENTER> | 227 | Tue | Johnson | ||||
<CENTER>4</CENTER> | 233 | Fri | Roosevelt, Washington | ||||
<CENTER>5</CENTER> | 3261 | Tue | Coolidge | ||||
<CENTER>6</CENTER> | 3261 | Wed | Coolidge | ||||
<CENTER>7</CENTER> | 3261 | Thu | Kennedy | ||||
<CENTER>8</CENTER> | 103 | Fri, Mon | Garfield, Harrison, Taylor | ||||
<CENTER>9</CENTER> | 103 | Tue | Tyler, Fillmore | ||||
<CENTER>10</CENTER> | 103 | Wed, Thu, Fri, Tue, Wed | Madison, McKinley, Wilson, Madison, McKinley, Wilson, Garfield, Tyler, Fillmore, Madison, McKinley, Wilson | ||||
<CENTER>11</CENTER> | 103 | Thu | Madison, McKinley, Wilson | ||||
<CENTER>12</CENTER> | 103 | Fri, Mon, Tue, Wed, Thu, Fri | Garfield, Harrison, Taylor, Tyler, Fillmore, Madison, McKinley, Wilson, Madison, McKinley, Wilson, Garfield | ||||
<CENTER>13</CENTER> | 103 | Mon, Tue, Wed | Harrison, Taylor, Tyler, Fillmore, Madison, McKinley, Wilson | ||||
<CENTER>14</CENTER> | 303 | Fri | Harding | ||||
<CENTER>15</CENTER> | 303 | Fri, Mon, Tue, Wed | Harding, Harding, Harding, Harding | ||||
<CENTER>16</CENTER> | 303 | Fri | Harding | ||||
<CENTER>17</CENTER> | 303 | Mon | Harding | ||||
<TBODY> </TBODY> |
<TBODY>
</TBODY>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>