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