I need some help with a formula, but I have no idea how to create it or what to use. Basically I have 3 columns of data, one is a list of SKUs (Column 1), another is a list of SKUs (Column 2), and the last is a list of prices (column 3).
Column 1 is by itself, and it represents items sold, so the same SKU can appear in column 1 more than once. Column 2 and 3 represent the SKU and it's cost respectively.
I would like to create a formula in a fourth column. It would be something like this: Take the value in column 1 and find that same value in column 2. Once the same value is found in column 2, give me the value to immediate right of column 2 in column 3.
I have created an example table with Column 4 representing the result I would like to have show.
Here is an example of how I would like to have it work (Looks at the table for refernce):
C1R1 is 5183. That matches with C2R2, and in C4R1 I would like the value from C3R2.
C1R2 is 4900. That matches with C2R5, and in C4R2 I would like the value from C3R5.
And so on and so on...
Column 1 Column 2 Column 3 Column 4 (Result)
Row 1 5183 720 4.03 9.87
Row 2 4900 5183 9.87 2.88
Row 3 710 5184 7.82 0.87
Row 4 710 5185 2.88
Row 5 720 4900 2.88
Row 6 4235 5190 0.27
Row 7 4275 5195 0.34
Row 8 4285 710 0.89
Row 9 4295 4235 1.45
Please let me know if I need to clarify anything.
Bookmarks