VLOOKUP difficulty: I don;t know what I'm doing wrong

[mister_eck]

I have a price list with vendor part numbers to which I need to add the part numbers that our work Point of sale system recognizes. Here's what I've got

Sheet 1: Column A: Vendor Part number; Column B: our part number
Example: Column A: 1AK0107: Column B: X82-520

Sheet 2: Column A: The column I want to put our number into; Column B: The vendor's part numbers; then more columns with prices, etc

I want to use a VLOOKUP formula in Column A of sheet 2 to look up our part number and insert it into column A. Thereby giving me one sheet with the part numbers that our computer recognizes and prices to go with them.

Here's the formula that I'm using in Column one of sheet two: =VLOOKUP(B2,Sheet1!A:B,2,FALSE)

Why isn't this working?

Thanks for any help.

[protonLeah]

To attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[FDibbins]

Based on your sample, it works for me...

	A	B
1	Sheet1
2	Vendor Part number	our part number
3	1AK0107	X82-520
4
5	Sheet2
6		The vendor's part numbers
7	X82-520	1AK0107

A7=VLOOKUP(B7,$A$3:$B$5,2,0)

If you are getting an error answer, check with part numbers you know should match - test them with =EXACT(ref1, ref2), if you get FALSE, check for leading and trailing spaces on both entries, see if you can see any differences betweenthe 2 entries

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.