I am trying to use the if statement, if a cell = a cell that has a word in it then show content of another cell that has a name in it.
I am trying to use the if statement, if a cell = a cell that has a word in it then show content of another cell that has a name in it.
the IF() statement compares values of the cells so
will compare the contents of A3 and b3 and if there is a match display the content of c3 else display nothingPlease Login or Register to view this content.
I must not have explained this very well sorry. Here is what have i have one cell that states =IF(D5<TODAY()-365,"needed","") Now i need a statement to indicate that if that cell has needed in it then i need it to print the name that is in a5
OK the best way to help send a non sensitive sample with the expected output in an excel sheet
Assuming the name you want to show is in cell A5, and your sample formula above is in cell E5 a formula like this would work: =IF(E5="needed",A5,"")
That worked
Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks