Hello,
I am trying to create a formula that I can compare a customer number on sheet1 (Column B) to sheet2 (Column A) and return the payment type provided on sheet2 Column B for sheet1 column C.
<tbody>
</tbody>
<tbody>
</tbody>
Thank you!
I am trying to create a formula that I can compare a customer number on sheet1 (Column B) to sheet2 (Column A) and return the payment type provided on sheet2 Column B for sheet1 column C.
Sheet1 | ||
A | B | C |
ABC Inc | 1234 | Formula here for Column B sheet2 return |
<tbody>
</tbody>
Sheet2 | ||
A | B | C |
1234 | ATM | ABC Inc |
<tbody>
</tbody>
Thank you!
Last edited: