Help with INDEX and MATCH Formulas

[Forrest87]

Hi all,

I am new to the site, so forgive me if I am unclear. I am struggling to perform a task on excel. I am trying to create a report to match data on 2 different worksheets and then return a specific cell value. I am new to INDEX and MATCH formulas but from my research I am thinking this formula maybe the best solution.

I have a code on Sheet 1 and code on Sheet 2. Say cell A on Sheet 1 matches a cell on Sheet 2 how can I get it to return the value in cell B onto a new column in Sheet 1?

Any help would be greatly appreciated

 

[Aladin Akyurek]

=VLOOKUP($A2,Sheet2!A:B,2,0)

Does this work which is invoked in B2 of Sheet1?

 

[Forrest87]

Hi Aladin,

Thank you so much, that's works. I was over complicating things ��

 

[Aladin Akyurek]

Hi Aladin,

Thank you so much, that's works. I was over complicating things ��

You are welcome.