Lookup function (i think)

S

Scott R

Hi Guys, I think I need a lookup function (which ive rarely used) and excel
help is confusing me...

I have sheet2 where col A has every date for this year, Col B has its
corresponding week # (1-52). Then, in sheet 1 i have several columns. Col B
has dates in it. I would like column A (currently blank) to have the relevant
week # for that year.

This is probably a simple lookup function but it has evaded me...

Any help would be appreciated...
 
M

Max

In Sheet1,
Assuming dates in B1 down
Put in A1:
=IF(B1="","",INDEX(Sheet2!B:B,MATCH(B1,Sheet2!A:A,0)))
Copy down as far as required
 
S

Scott R

Thanks heaps for that! Worked Great!
Scott

Max said:
In Sheet1,
Assuming dates in B1 down
Put in A1:
=IF(B1="","",INDEX(Sheet2!B:B,MATCH(B1,Sheet2!A:A,0)))
Copy down as far as required
Click to expand...
 
Top