Excel Help - If, Match Then X

[Nwarga]

If Column A in spreadsheet 1 matches column A in spreadsheet 2, then column C in worksheet 1 equals result from Column B in spreadsheet 2.

What’s this formula need to look like? Cannot figure it out.

Column A in both sheets have skus. I need to match these up. Then, I need the item description (from worksheet 2 in column B) to feed into spreadsheet 1 - and into column C.

 

[MountainFog]

Do they need to be in the same row? Because it would seem easiest to do a lookup/indexmatch

 

[Nwarga]

Do they need to be in the same row? Because it would seem easiest to do a lookup/indexmatch

The data is not in the same row.

 

[Scott Huish]

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