tkroper
Active Member
- Joined
- Feb 2, 2007
- Messages
- 255
Help!
I have two sheets, each with 4-digit codes in column A (except some codes in sheet1 have 5 digits). Sheet2 also contains dollar amounts in column B.
I need a formula for sheet1 that will return the dollar amount from sheet2 for the matching code.
Example:
Sheet1
8601(4)
8813(1)
9015(5)
Sheet2
<tbody>
</tbody><colgroup><col><col></colgroup>
I have two sheets, each with 4-digit codes in column A (except some codes in sheet1 have 5 digits). Sheet2 also contains dollar amounts in column B.
I need a formula for sheet1 that will return the dollar amount from sheet2 for the matching code.
Example:
Sheet1
8601(4)
8813(1)
9015(5)
Sheet2
8601 | 6.08 |
8813 | 10.26 |
9015 | 8.22 |
<tbody>
</tbody><colgroup><col><col></colgroup>