Two Criteria to Get one Answer

[Ant20000]

Hi There,

I could really use some help.

I am trying to figure out a way of looking up sale data though it must be for a certain week and certain SKU. The sheet i currently have has the weeks in the columns and SKU in the rows, whilst i have the sales data on a seperate sheet containing the sku, multiply weeks ( numbered ) and sales numbers.

I have tried a IF and Countif statement with a nested vlookup, however whilst the IF statement if producing the correct result ( by saying week 40 exists therefore producing a 'true' result ) the Vlook up is then finding the 1st occurrence of the SKU and populates that figure and not the figure i require.

Is there anyway a formula exists that will check a particular cell in a range contains the right week, allowing the vlook to then pull the right figure?

 

[etaf]

if this is a grid , which your description sounds like

SKU in the rows , sat A2 to A20000
and the weeks in the column heading B1: Z1

is that the layout and you need to look down the column A rows to find the Sku and then along the columns to the weeknumber and then the intersection is the result you need
if so , this tutorial will help

http://skp.mvps.org/xl00002.htm

if not , please explain again