tracyblome
New Member
- Joined
- Jan 6, 2014
- Messages
- 11
I am so confused. I have been working on this for two days now and can't seem to figure it out. I am working on this for a co-worker.
She has a spreadsheet that has two different columns for product numbers and the quantity for each product number. How can I compare each product number and the quanitity to see if they match? I have approximately 4,000 different rows in each so using VLOOKUP would seem so much easier but I can't seem to use the right formula.
<COLGROUP><COL style="WIDTH: 151pt; mso-width-source: userset; mso-width-alt: 7350" width=201><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 151pt; mso-width-source: userset; mso-width-alt: 7350" width=201><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><TBODY>
</TBODY>
She has a spreadsheet that has two different columns for product numbers and the quantity for each product number. How can I compare each product number and the quanitity to see if they match? I have approximately 4,000 different rows in each so using VLOOKUP would seem so much easier but I can't seem to use the right formula.
Product # | QTY | Product # | QTY |
260005 | 344 | 260005 | 344 |
260025 | 2,294 | 260025 | 2,294 |
260026 | 720 | 260026 | 720 |
260030 | 220 | 260030 | 220 |
260052 | 4 | 260052 | 4 |
260053 | 13 | 260053 | 13 |
260101 | 2,030 | 260101 | 2,030 |
266001 | 21 | 266001 | 21 |
266003 | 44 | 266003 | 44 |
266007 | 57 | 266007 | 57 |
266015 | 21 | 266015 | 21 |
270090 | 15 | 270090 | 15 |
270091 | 11 | 270091 | 11 |
270098 | 15 | 270098 | 15 |
270099 | 99 | 270099 | 99 |
270100 | 82 | 270100 | 82 |
272057 | 1,340 | 272057 | 1,340 |
272174 | 121 | 272174 | 121 |
272218 | 105 | 272218 | 105 |
272222 | 68 | 272222 | 68 |
272305 | 22 | 272305 | 22 |
280001 | 1,176 | 280001 | 1,176 |
280003 | 5,040 | 280003 | 5,040 |
280004 | 9,370 | 280004 | 9,370 |
<COLGROUP><COL style="WIDTH: 151pt; mso-width-source: userset; mso-width-alt: 7350" width=201><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 151pt; mso-width-source: userset; mso-width-alt: 7350" width=201><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><TBODY>
</TBODY>