What I am trying:
When I type a number in column G (Project activities sheet) it must show column B in Status sheet column A
I have tried using :=IF('Project Activities'!H5<=1,'Project Activities'!C5)
But when I pull this formula down I am getting all of them and would only like to get the ones if their is a number in line G (Project activities sheet)
Thanks
Bookmarks