Hi,

I'm really not sure as to why my Vlookup formula is not working:

=VLOOKUP(sheet1!A2:A127, sheet2!A2:B57,2, FALSE)

What I am trying to achieve, is for Excel to look at values in Column A in sheet 1, and compare them to values in Column A in sheet 2. If they are equal, I would like it to return the value in Column B of sheet 2.

Another potential hurdle is that there are more values in sheet 1 then sheet 2, so sorting columns alphabetically will not keep them corresponding (if that makes sense).

As it currently stands, it's giving me a #N/A for return value.

-Thank you