Index and Match Formula Help

[MurraySMTH]

Hello all,

I want to compare 2 worksheets. I was trying a vlookup/Index/match... but no success.

The first worksheet Sheet1 column C should match with sheet2 column B

Sheet 2 also matches a value in column P.

I want to match that value an return in column AR

See picture below:

COLUMN AR Sheet 1 is where the value would populate

Any help is appreciated.

 

[Wookiee]

It looks like you just need VLOOKUP. Try this formula in cell AR2 on Sheet 1:

=VLOOKUP($C2,'Sheet 2'!B:P,15,0)

 

[Eric W]

Try:

=INDEX(Sheet2!$P$2:$P$5,MATCH(C2,Sheet2!$B$2:$B$5,0))

 

[MurraySMTH]

Guys! yall don't know how long I have been doing this!! Yall are the best! both worked!!!!