Hi,
I am not sure what I need to do here a vlookup or possibly a macro.
I have included an example spreadsheet. I would like to look at column C2 and lookup the number in column G. If the coorresponding cell in H is listed as a project then I would like to change what was listed in Column B2 to Project1 otherwise Project2. And on down the list.
Any assitance would be appriciated...
Thanks!
Book1.xlsx
Bookmarks