Lookup function (i think)

[Guest]

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...

 

[Guest]

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

 

[Guest]

Thanks heaps for that! Worked Great!
Scott

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

 

[Max]

welcome, glad to hear that.