hi all,
i think this is easy for a pro...
i have two tabs, a helper tab to pull info from, onto the "report" worksheet.
on the report sheet, user names are only listed once. then there are four groups of data column, with a date (undr the name header) and a status column.
i need the vlookup on the report sheet to look at the name in column B, find that name in column B on the helper sheet and if the name column C is not blank, report back the date in column C and teh status in column D.
can someone please help a newbie?
Bookmarks