I need a formula to to look a 3 different columns and if any contain the number 6, return the value of a different cell. For example:
If F4 or G4 or H4 contain the number 6, return the content in A4.
Thanks!
This message was edited by brendakc on 2002-09-02 19:40
If F4 or G4 or H4 contain the number 6, return the content in A4.
Thanks!
This message was edited by brendakc on 2002-09-02 19:40