Select value from cell if 2 criteria are met
Closed
learningslowly
-
May 6, 2010 at 10:39 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 05:45 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 7, 2010 at 05:45 AM
Related:
- Select value from cell if 2 criteria are met
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Plants vs zombies 2 pc download - Download - Strategy
- Vba select case like - Guide
- Five nights in anime 2 - Download - Adult games
- Count if cell contains number - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
May 7, 2010 at 05:45 AM
May 7, 2010 at 05:45 AM
You can try this
=IF(AND(A1="AC", C1="J5"),F!1, "")
for more
=IF(AND(A1="AC", C1="J5"),F!1, IF(AND(AC1="AC2", C1="J52"), E1, ""))
You can up to seven nested if. If you have more than 7 nested if (if within another if, then you have to use macro or do some thing else (depending on situation)
=IF(AND(A1="AC", C1="J5"),F!1, "")
for more
=IF(AND(A1="AC", C1="J5"),F!1, IF(AND(AC1="AC2", C1="J52"), E1, ""))
You can up to seven nested if. If you have more than 7 nested if (if within another if, then you have to use macro or do some thing else (depending on situation)