Hi, in attached file, B1:D5 is the Criteria to meet to return the Type Column. Its a OR criteria. Which mean if one of the Criteria is met, it will belong to the Respective type.
I done up a example in J:L, and my formula is F:I. However, it required 3 helper column. If i combine all into 1. It will required many IF and will be very long.
ANyone can help to see if its possible to come up with another way?
Here's the 202-character nested IF formula (I think):
WITHDRAWN- Proposal did not suit requirements.
I'm confused. Two different states share OR conditions [W2,W3] = [P2,P3]. How does that work?
Last edited by leelnich; 03-07-2018 at 11:49 PM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks