Match/index look up for text

[NyxieMoon]

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.

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!

 

[snjpverma]

Try this

Adjust the ranges as per your requirement

=VLOOKUP(A1&B1,IF({1,0},INDEX(Sheet2!A1:A25&Sheet2!C1:C25,0),Sheet2!B1:B25),2,0)

 

[Nine Zero]

Try this out

=INDEX(Sheet2!B:B,MATCH(Sheet1!A1&Sheet1!B1,Sheet2!A:A&Sheet2!C:C,0))

Array formula so submit with CTRL + SHIFT + ENTER

 

[NyxieMoon]

Hello,

Thank you both for your quick responses however neither work. I tried to ask this pretty generic, however I am probably not able to modify the formula for what I need it to be. I also am really inexperienced and not sure how to even submit the array; I did have CTRL and SHIFT held down while I pressed enter, however it tried to make me either save or pull up another file altogether.

I am going to ask it specifically. Thank you again!

Future Tab
Company Name	Customer Number	Payment Type (Need formula here)
ABC Inc	1234
Blue Co	4321

<tbody>
</tbody>

Payment Tab
Customer Number	Payment Type	Company Name
1234	Check	ABC Inc
4321	Visa	Blue Co

<tbody>
</tbody>

 

[snjpverma]

I think the name of your sheet 2 is "Payment", so you need to make the necessary changes. Also, you have made changes to your sheet 1 in post 1 above..

I made the below changes accordingly,

Just Enter

=VLOOKUP(B1&A1,IF({1,0},INDEX(Payment!A1:A25&Payment!C1:C25,0),Payment!B1:B25),2,0)