I need to have more than 7 embdded IF statements, which excel will not allow. Is there an easy work-around? The IF statements are straight forward =IF($F$25="JOE",A1,IF($F$25="JOHN",B1, etc., etc.). I just happen to have 12 guys (Joe, John, Bob, Dave, Bill, etc., etc.) and I need to embed 12 If statements.
The Excel Help states to use the LOOKUP function, but I can't get that to work.
Any help would be greatly appreciated. Thanks.
The Excel Help states to use the LOOKUP function, but I can't get that to work.
Any help would be greatly appreciated. Thanks.