Don't know what's wrong with Vlookup

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

Originally Posted by Norie

Is the value in A2 on Sheet1 the same data type, eg string/number, as that of the values in A2:B57 on Sheet2?

Yes, everything is text. Maybe it would help mentioning the values I'm trying to match up are emails.

Originally Posted by Norie

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Hi Norie, unfortunately I don't think it's information I have permission to share, otherwise I would absolutely do it.

But from your point of view, the formula seems accurate?

Originally Posted by NBVC

Try, in Sheet1:

=VLOOKUP(A2, sheet2!$A$2:$B$57,2, FALSE)

and copy down.

Hi NBVC,

Where does the name of the first sheet go?

-Thank you

Originally Posted by NBVC

Please elaborate.

Do you mean this? http://www.xl-central.com/lookup-sin...le-sheets.html

I don't think so. I would like to match data in sheet 1 with data in sheet 2 and 3 for example, and return matched values in 1 return cell. Exactly as in my original post, but returning values of multiple sheets in one cell.

-Thank you

Originally Posted by timko92

I don't think so. I would like to match data in sheet 1 with data in sheet 2 and 3 for example, and return matched values in 1 return cell. Exactly as in my original post, but returning values of multiple sheets in one cell.

-Thank you

Hi, please disregard that last question. I figured it out. Thank you for your help.