Vlookup and concatenate

[lemonap618]

Hello All,
I hope this message finds you all well.
I must admit I'm in a little over my head here. What I trying to accomplish is to combine a Vlookup and concatenate function. On sheet 1 I have two inputs - company code and credit account. These two values need to be used as my lookup_value in my Vlookup function. On sheet 2, I need to find the rating (column "I").
Could someone help me here?

I know I could add a column to Sheet 2 and concatenate the credit account and company code and then use Vlookup. However, I would like to not have to do that. All help and suggestions are welcomed!

Thanks!

[Sam Capricci]

this will work =INDEX(Sheet2!I2:I13,MATCH(Sheet1!C2&Sheet1!C3,Sheet2!J2:J13,0)) if you put this in cell J2 of sheet2 and drag down... =A2&B2 (helper column)

had to change the sheet2 formula slightly from I1:I13 to I2:I13

[bebo021999]

May be:

=LOOKUP(2,(Sheet2!A:A=Sheet1!C2)/(Sheet2!B:B=Sheet1!C3),Sheet2!I:I)

[hemesh]

or may be
copy paste below then hold control and shift together and then hit enter to make it array formula
=INDEX(Sheet2!$I$2:$I$13,MATCH(Sheet1!C2&Sheet1!C3,Sheet2!A2:A13&Sheet2!$B$2:$B$13,0))

[lemonap618]

These all work wonderfully....thank you all for your very quick responses

[Sam Capricci]

if your issue was solved please don't forget to mark your post as solved using the thread tools dropdown at the top of the post.
And you can thank any and all who helped you by clicking on the "*add reputation" below their posts.