scottlarock
Board Regular
- Joined
- Apr 10, 2009
- Messages
- 102
Hello,
I have been trying to ask my question right, I hope it is somewhat clear this time.
I am trying to return the matching price in column L as found in column D according to H, I, J, which should match A, B, C.
The exercise consists in comparing the prices found in column D with those in column K.
Could anyone tell me what the formula would be in column L ?
I know, this sounds very easy, but I just don't have the excel logic to work this out.... All I can do is a simple 1 criteria vlookup but that doesn't suffice on the real db.
Thank you all so much for the time and support !
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
I have been trying to ask my question right, I hope it is somewhat clear this time.
I am trying to return the matching price in column L as found in column D according to H, I, J, which should match A, B, C.
The exercise consists in comparing the prices found in column D with those in column K.
Could anyone tell me what the formula would be in column L ?
I know, this sounds very easy, but I just don't have the excel logic to work this out.... All I can do is a simple 1 criteria vlookup but that doesn't suffice on the real db.
Thank you all so much for the time and support !
A</SPAN> | B</SPAN> | C</SPAN> | D</SPAN> | E</SPAN> | F</SPAN> | G</SPAN> | H</SPAN> | I</SPAN> | J</SPAN> | K</SPAN> | L</SPAN> | M</SPAN> | |
1</SPAN> | Major</SPAN> | Item code</SPAN> | Description</SPAN> | Price</SPAN> | Major</SPAN> | Item code</SPAN> | Description</SPAN> | Price</SPAN> | Compared price</SPAN> | ||||
2</SPAN> | Music</SPAN> | Mic Pump 1</SPAN> | Mic Pump 1</SPAN> | 100.00</SPAN> | Music</SPAN> | Mic1</SPAN> | Mic Pump 1</SPAN> | 102.00</SPAN> | |||||
3</SPAN> | Music</SPAN> | Mic Pump 2</SPAN> | Mic Pump 2</SPAN> | 120.00</SPAN> | Music</SPAN> | Mic 2</SPAN> | Mic Pump 2</SPAN> | 122.00</SPAN> | |||||
4</SPAN> | Music</SPAN> | Mic Pump 3</SPAN> | Mic Pump 3</SPAN> | 130.00</SPAN> | Music</SPAN> | Mic 3</SPAN> | Mic Pump 3</SPAN> | 132.00</SPAN> | |||||
5</SPAN> | Music</SPAN> | Mic Pump 4</SPAN> | Mic Pump 4</SPAN> | 150.00</SPAN> | Music</SPAN> | Mic 4</SPAN> | Mic Pump 4</SPAN> | 152.00</SPAN> | |||||
6</SPAN> | Music</SPAN> | Mic Pump 5</SPAN> | Mic Pump 5</SPAN> | 170.00</SPAN> | Music</SPAN> | Mic 5</SPAN> | Mic Pump 5</SPAN> | 172.00</SPAN> | |||||
7</SPAN> | Music</SPAN> | Mic Pump 6</SPAN> | Mic Pump 6</SPAN> | 190.00</SPAN> | Music</SPAN> | Mic 6</SPAN> | Mic Pump 6</SPAN> | 192.00</SPAN> | |||||
8</SPAN> | Music</SPAN> | Mic Pump 7</SPAN> | Mic Pump 7</SPAN> | 200.00</SPAN> | Music</SPAN> | Mic 7</SPAN> | Mic Pump 7</SPAN> | 202.00</SPAN> | |||||
9</SPAN> | Music</SPAN> | Mic Pump 8</SPAN> | Mic Pump 8</SPAN> | 220.00</SPAN> | Music</SPAN> | Mic 8</SPAN> | Mic Pump 8</SPAN> | 222.00</SPAN> | |||||
10</SPAN> | Music</SPAN> | Mic Pump 9</SPAN> | Mic Pump 9</SPAN> | 240.00</SPAN> | Music</SPAN> | Mic 9</SPAN> | Mic Pump 9</SPAN> | 242.00</SPAN> | |||||
11</SPAN> | Music</SPAN> | Mic Pump 10</SPAN> | Mic Pump 10</SPAN> | 260.00</SPAN> | Music</SPAN> | Mic 10</SPAN> | Mic Pump 10</SPAN> | 262.00</SPAN> | |||||
12</SPAN> | Music</SPAN> | Mic Pump 11</SPAN> | Mic Pump 11</SPAN> | 280.00</SPAN> | Music</SPAN> | Mic 11</SPAN> | Mic Pump 11</SPAN> | 282.00</SPAN> | |||||
13</SPAN> | Music</SPAN> | Mic Pump 12</SPAN> | Mic Pump 12</SPAN> | 300.00</SPAN> | Music</SPAN> | Mic 12</SPAN> | Mic Pump 12</SPAN> | 302.00</SPAN> | |||||
14</SPAN> | Music</SPAN> | Mic Pump 13</SPAN> | Mic Pump 13</SPAN> | 320.00</SPAN> | Music</SPAN> | Mic 13</SPAN> | Mic Pump 13</SPAN> | 322.00</SPAN> | |||||
15</SPAN> | Cinema</SPAN> | Vid Pump 1</SPAN> | Mic Pump 14</SPAN> | 340.00</SPAN> | Cinema</SPAN> | Mic 14</SPAN> | Vid Pump 6</SPAN> | 342.00</SPAN> | |||||
16</SPAN> | Cinema</SPAN> | Vid Pump 2</SPAN> | Mic Pump 15</SPAN> | 360.00</SPAN> | Cinema</SPAN> | Mic 15</SPAN> | Vid Pump 7</SPAN> | 362.00</SPAN> | |||||
17</SPAN> | Cinema</SPAN> | Vid Pump 3</SPAN> | Mic Pump 16</SPAN> | 380.00</SPAN> | Cinema</SPAN> | Mic 16</SPAN> | Vid Pump 8</SPAN> | 382.00</SPAN> | |||||
18</SPAN> | Cinema</SPAN> | Vid Pump 4</SPAN> | Mic Pump 17</SPAN> | 400.00</SPAN> | Cinema</SPAN> | Mic 17</SPAN> | Vid Pump 9</SPAN> | 402.00</SPAN> | |||||
19</SPAN> | Cinema</SPAN> | Vid Pump 5</SPAN> | Mic Pump 18</SPAN> | 420.00</SPAN> | Cinema</SPAN> | Mic 18</SPAN> | Vid Pump 10</SPAN> | 422.00</SPAN> | |||||
20</SPAN> | Cinema</SPAN> | Vid Pump 6</SPAN> | Mic Pump 19</SPAN> | 440.00</SPAN> | Cinema</SPAN> | Mic 19</SPAN> | Vid Pump 11</SPAN> | 442.00</SPAN> | |||||
21</SPAN> | Cinema</SPAN> | Vid Pump 7</SPAN> | Mic Pump 20</SPAN> | 460.00</SPAN> | Cinema</SPAN> | Mic 20</SPAN> | Vid Pump 12</SPAN> | 462.00</SPAN> | |||||
22</SPAN> | Cinema</SPAN> | Vid Pump 8</SPAN> | Mic Pump 21</SPAN> | 480.00</SPAN> | Cinema</SPAN> | Mic 21</SPAN> | Vid Pump 1</SPAN> | 482.00</SPAN> | |||||
23</SPAN> | Cinema</SPAN> | Vid Pump 9</SPAN> | Mic Pump 22</SPAN> | 500.00</SPAN> | Cinema</SPAN> | Mic 22</SPAN> | Vid Pump 2</SPAN> | 502.00</SPAN> | |||||
24</SPAN> | Cinema</SPAN> | Vid Pump 10</SPAN> | Mic Pump 23</SPAN> | 520.00</SPAN> | Cinema</SPAN> | Mic 23</SPAN> | Vid Pump 3</SPAN> | 522.00</SPAN> | |||||
25</SPAN> | Cinema</SPAN> | Vid Pump 11</SPAN> | Mic Pump 24</SPAN> | 540.00</SPAN> | |||||||||
26</SPAN> | Cinema</SPAN> | Vid Pump 12</SPAN> | Mic Pump 25</SPAN> | 560.00</SPAN> | |||||||||
27</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>