Hi,
I have entered a VLOOKUP to search an Item no. and return the amount in sold
in the month. The VLOOKUP returns the closest value from the nearest item no.

Should I use an IF function so that it will only put in a value if the item
number matches exactly?

Can anyone help?

Thank you in advance,
Nicole