Lookup formulas

hi,

I'm trying to combine two worksheets, one downloaded from MYOB, one our price list.

I need to enter the Barcode for each item, from the MYOB report into the price list.

I guess I need a formula, that says :

Find the Part no. is worksheet 1 and 2, and copy the barcode cell value to the other worksheet.

Thank you

vlookup is the formula that does it. Tell me the following and I will construct the formula for you:
- which column is the part no in your price list
- which column do you want to enter the barcode
- which column have the part no in the MYOB
- which column have the barcode in the MYOB

Thank you, that would be awsome.

1. Part no. on the price list is in columm A
2. Barcode on price list is in column C
3. Part no on the MYOB report is in colum B
4. Barcode on the MYOB report is in column E.

Thank you

Tinoca

You want the barcode to show in your pricelist column C, so that is where you will construct the formula. In the end it will look almost like this: =VLOOKUP(A2,[MYOB.xlsm]Sheet1!$B:$E,4,FALSE)

So in C2 in your pricelist, start typing "=vlookup(" The first input into the formula after the first bracket is the values which are common and need to be matched, in your case the Part No which is in column A, so the first input is A2. "=vlookup(A2"

Now you should tell the formula where the match is for that Part No and where the Barcode is which it should return, but the input should be a table, so after the A2 enter your comma "," and highlight columns B to E in your MYOB.

Enter "," for your next input, count the columns from the Part No to the Barcode in the MYOB (Part No included) it's number 4. Enter the 4

"," for your last input, which is the word FALSE in order to make an exact match.