Help, stuck on excel equation

[NewYawk]

I am not sure if I am using the correct equation for what I am trying to do, but vlookup does not seem to work.

My Need: To take 2 product spreadsheets organized in columns, match a sku number and upon matching a sku between the 2, input a fields value (image name). So, for example, if spreadsheet 1 has a matching sku to spreadsheet 2, then it would input the value in the 1st spreadsheet from the second spreadsheets image column (corresponding to sku)

Each time I have tried Vlookup, I get an NA. It all seems to crumble when I use the column number function. All else seems to work (false, etc). Am I even using the correct formula to attempt this action?

Thanks in advance

 

[Andrew Poulsom]

Welcome to MrExcel.

It might help if you posted your formula that isn't working.

 

[VoG]

VLOOKUP should work. See if this tutorial helps http://www.contextures.com/xlFunctions02.html