Leather Mouse
Leather Mouse
Excel formula?
I have two columns with the following information: ………… 1 ………. 2 …………… 3 COL A: bat ….. cat ……….. cabbage leather B: six …… …. mouse col bag C: leather I need a formula for the "bag" in D by comparing C with a colleague result D: bag
assuming there are 3 values in each column, then it should contain cell D1: = VLOOKUP (INDEX (C1, 1), $ A $ 1: $ B $ 3,2) Fill down column D, and will everything ready. If you have more than three items in columns A and B, then change $ B $ 3 to $ B $
|
|
Leather Mouse Pad with Calculator and World Time Clock $29.99 |
|
|
Leather Mouse Pad with Calculator and World Time Clock $29.99 |
|
|
Royce Leather Leather Mouse Pad – Blue $28.00 |
|
|
Royce Leather Leather Mouse Pad – Black $28.00 |
|
|
Royce Leather Leather Mouse Pad – Tan $28.00 |
|
|
Royce Leather Leather Mouse Pad – Black $20.00 |
|
|
New Leather Mouse Pad w Calculator & World Time Clock $29.99 |
|
|
Leather Mouse Pad with Calculator and World Time Clock $29.99 |
|
|
Leather Mouse Pad & Glass Paperweight set – Black-Teal $29.99 |
|
|
New Leather Mouse Pad w Calculator & World Time Clock $29.99 |
|
|
Datexx Leather Mouse Pad wi Calculator & World Time Clk $29.99 |