#### clara200

##### New Member

- Joined
- Jul 19, 2006

- Messages
- 28

I am having a few problems with a Vlookup formula. I am using the formula for the purpose of matching off a value eg “PAZU123” with what that value corresponds to in another sheet.

For instance if Sheet 1 has the value “PAZU123” and the value $1000 in the column beside it

that where PAZU123 occurs in Sheet 2 that it will place $1000 in the column beside it.

At the moment I am using the formula: =VLOOKUP(I1,VAT!$L$1:$M$5000,2,FALSE)

It works fine if the value eg PAZU001 occurs only once. The problem arises when the value eg PAZU001 occurs more than once. In other words PAZU001 occurs three or four times each time with a different amount eg $1000, $2678 etc. When this happens it gives me only the first value it finds for the three or four times PAZU001 occurs on Sheet 2. I was wondering was there a way Vlookup would actually give me the correct amounts on Sheet 2 relative to the amounts on sheet 1.

Below is a formula I made up to tell me when the error occurs every time a value occurs more than once eg PAZU001 that the word same will appear in the cell instead of the value on Sheet 1.

=IF(I2=I1,"SAME",VLOOKUP(I186,VAT!$L$1:$M$5000,2,FALSE))

Is there anyway around this problem apart from me manually entering the duplicate values myself. I would greatly appreciate any help going.

Thanks,

Seán.