Lookup Help

[excel2012]

Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">1st Table</td><td style="font-weight: bold;text-align: center;;">
</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="font-weight: bold;text-align: center;;">
</td><td style="font-weight: bold;text-align: center;;">
</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;;">S.#</td><td style="font-weight: bold;text-align: center;;">Operations</td><td style="font-weight: bold;text-align: center;;">Rate</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Fly Round</td><td style="font-weight: bold;text-align: center;;">0.3</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-align: center;;">02</td><td style="font-weight: bold;;">Fly Over Lock</td><td style="font-weight: bold;text-align: center;;">0.5</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="font-weight: bold;text-align: center;;">03</td><td style="font-weight: bold;;">Crotch</td><td style="font-weight: bold;text-align: center;;">0.2</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="font-weight: bold;text-align: center;;">04</td><td style="font-weight: bold;;">Front Pocket Top</td><td style="font-weight: bold;text-align: center;;">0.1</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-align: center;;">05</td><td style="font-weight: bold;;">Back Pocket Top</td><td style="font-weight: bold;text-align: center;;">0.3</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="font-weight: bold;text-align: center;;">06</td><td style="font-weight: bold;;">Back Pocket Hem</td><td style="font-weight: bold;text-align: center;;">0.5</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="font-weight: bold;text-align: center;;">07</td><td style="font-weight: bold;;">Back Pocket Attach</td><td style="font-weight: bold;text-align: center;;">0.3</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="font-weight: bold;text-align: center;;">08</td><td style="font-weight: bold;;">Side Top</td><td style="font-weight: bold;text-align: center;;">0.2</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="font-weight: bold;text-align: center;;">09</td><td style="font-weight: bold;;">Back Yoke</td><td style="font-weight: bold;text-align: center;;">0.5</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="font-weight: bold;text-align: center;;">10</td><td style="font-weight: bold;;">Back Rise</td><td style="font-weight: bold;text-align: center;;">0.4</td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style="font-weight: bold;text-align: center;;">11</td><td style="font-weight: bold;;">Bottom Hem</td><td style="font-weight: bold;text-align: center;;">0.3</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="font-weight: bold;text-align: center;;">12</td><td style="font-weight: bold;;">Band End Upper</td><td style="font-weight: bold;text-align: center;;">0.1</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="font-weight: bold;text-align: center;;">13</td><td style="font-weight: bold;;">Band End Lower</td><td style="font-weight: bold;text-align: center;;">0.6</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="font-weight: bold;text-align: center;;">14</td><td style="font-weight: bold;;">Label Attach</td><td style="font-weight: bold;text-align: center;;">0.5</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="font-weight: bold;text-align: center;;">15</td><td style="font-weight: bold;;">Button Tack</td><td style="font-weight: bold;text-align: center;;">0.3</td></tr><tr><td style="color: #161120;text-align: center;">19</td><td style="font-weight: bold;text-align: center;;">16</td><td style="font-weight: bold;;">Fly Top</td><td style="font-weight: bold;text-align: center;;">0.4</td></tr><tr><td style="color: #161120;text-align: center;">20</td><td style="font-weight: bold;text-align: center;;">17</td><td style="font-weight: bold;;">Inseam</td><td style="font-weight: bold;text-align: center;;">0.5</td></tr><tr><td style="color: #161120;text-align: center;">21</td><td style="font-weight: bold;text-align: center;;">18</td><td style="font-weight: bold;;">Outseam</td><td style="font-weight: bold;text-align: center;;">0.6</td></tr><tr><td style="color: #161120;text-align: center;">22</td><td style="font-weight: bold;text-align: center;;">19</td><td style="font-weight: bold;;">Loops Attach</td><td style="font-weight: bold;text-align: center;;">0.4</td></tr><tr><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">
</td><td style=";">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">24</td><td style="font-weight: bold;text-align: center;;">2nd Table</td><td style="font-weight: bold;text-align: center;;">
</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">25</td><td style="font-weight: bold;text-align: center;;">
</td><td style="font-weight: bold;text-align: center;;">
</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">26</td><td style="font-weight: bold;text-align: center;;">Frequency</td><td style="font-weight: bold;text-align: center;;">Operations</td><td style="font-weight: bold;text-align: center;;">Rate</td></tr><tr><td style="color: #161120;text-align: center;">27</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Fly Round</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">28</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Fly Over Lock</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Crotch</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">30</td><td style="font-weight: bold;text-align: center;;">02</td><td style="font-weight: bold;;">Crotch</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">31</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Front Pocket Top</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">32</td><td style="font-weight: bold;text-align: center;;">02</td><td style="font-weight: bold;;">Front Pocket Top</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">33</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Back Pocket Top</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">34</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Back Pocket Hem</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">35</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Back Pocket Attach</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">36</td><td style="font-weight: bold;text-align: center;;">02</td><td style="font-weight: bold;;">Back Pocket Attach</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">37</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Side Top</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">38</td><td style="font-weight: bold;text-align: center;;">02</td><td style="font-weight: bold;;">Side Top</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">39</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Back Yoke</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">40</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Back Rise</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">41</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Bottom Hem</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">42</td><td style="font-weight: bold;text-align: center;;">02</td><td style="font-weight: bold;;">Bottom Hem</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">43</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Band End Upper</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">44</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Band End Lower</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">45</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Label Attach</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">46</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Button Tack</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">47</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Fly Top</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">48</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Inseam</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">49</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Outseam</td><td style="font-weight: bold;text-align: center;;">
</td></tr><tr><td style="color: #161120;text-align: center;">50</td><td style="font-weight: bold;text-align: center;;">01</td><td style="font-weight: bold;;">Loops Attach</td><td style="font-weight: bold;text-align: center;;">
</td></tr></tbody></table>

Sheet2​

I want to know that for instance i have 2 different tables as shown above in first table i have all operations name and another also but here is a difference btw both tables is that in 2nd table some operations are repeated due to some reason, i want that when in second table i manually put in frequency column for instance "1" then the first operation name of the 1st tabel should show and again i type in frequency column for instance "1" so the 2nd name from 1st table should show but whenever i type in frequency column "2" so the above name of the "2nd table" should show, i hope i am making sense, for reference i have shown 2nd table with desired result, thanks and waiting for your reply...

 

[Philindo Gaddi]

To clarify, you want the 1st table is your basis. if you typed the no. 1 in cell A27 the name should appear in cell B27 is Fly Round? is this right.

 

[Laurent C]

Take a look at the INDEX function. It lets you get the cell placed at the i-th row and j-th column of a range.

 

[excel2012]

To clarify, you want the 1st table is your basis. if you typed the no. 1 in cell A27 the name should appear in cell B27 is Fly Round? is this right.

Yes you are right...

 

[excel2012]

Take a look at the INDEX function. It lets you get the cell placed at the i-th row and j-th column of a range.

can you explain it more?

 

[Laurent C]

For example, the formula
=INDEX(A4:C22, 4, 3)
will return the cell at the 4th row and the 3rd column in the range A4:C22.

That is, the value in C7.

 

[Philindo Gaddi]

Sorry for the late reply,

Please do this. I assume that your table is exactly located at range A3:D50.
type the formula in the 2nd table

Frequency Operations
1 =INDEX($B$4:$B$22,MATCH(A27,$A$4:$A$22,0))


the operations should return fly round. hope this help.

Yes you are right...