Comparing three columns and giving back specified values
Closed
sepideh.ha
Posts
1
Registration date
Monday July 28, 2014
Status
Member
Last seen
July 28, 2014
-
Jul 28, 2014 at 11:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 29, 2014 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 29, 2014 at 11:57 AM
Related:
- Comparing three columns and giving back specified values
- Display two columns in data validation list but return only one - Guide
- How to combine debit and credit columns in excel ✓ - Excel Forum
- How to compare two columns and return values from the third ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 29, 2014 at 11:57 AM
Jul 29, 2014 at 11:57 AM
Hi Sepideh.ha,
Next time posting a pic change 325px in 500px at the end of the picture code line, so that is actually readable (I don't blame you for not knowing).
Your query is rather vague. I get that you want to compare column A to E and H (I believe those are the column letter from the pic).
So if A=E and A=H then ... And there you lost me. Which data you want to put where is not clear to me.
Best regards,
Trowa
Next time posting a pic change 325px in 500px at the end of the picture code line, so that is actually readable (I don't blame you for not knowing).
Your query is rather vague. I get that you want to compare column A to E and H (I believe those are the column letter from the pic).
So if A=E and A=H then ... And there you lost me. Which data you want to put where is not clear to me.
Best regards,
Trowa
