Help with vlookup/match function

Hi all,

Ive been trying to get this sorted for a few weeks not but seem to be failing.

I have a spread sheet which is emailed to me (at work) every friday. It has lists of numbers in column A and B and in C i need to record how many of each we hold. See screen shot...
http://xs311.xs.to/xs311/07040/shot3.png
This spread sheet changes each week and cannot be edited in any way. The only cells open for editing are the ones highlighted in pale blue in my screen shot.

All the information I need to complete the spreadsheet sent to me comes from a spread sheet I have designed that looks like this...
http://xs511.xs.to/xs511/07040/shot4.png
This spreadsheets works of various other sheets.

My plan was to use vlookup in the spreadsheet that is emailed weekly to make my job a whole lot easier. The only problem is that the weekly spreadsheet contains numbers that do not appear inmy self made spreadsheet so the formula returns the closest match.

Thank you for any help in advance.

Emma

Hi Emma,

If you only want to return only exact matches (I think this is what your asking), use FALSE for the optional range_lookup part of the argument, i.e.
VLOOKUP(B1,A2:B6,2,FALSE).

Hope this helps.

Robert

Cool,

Ill try it at work tomorrow and let you know.

Thanks for your help.

Emma