Comparing columns and returning value
Closed
Gunhild
-
Jan 11, 2012 at 05:38 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 12, 2012 at 10:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 12, 2012 at 10:08 PM
Related:
- Comparing columns and returning value
- Display two columns in data validation list but return only one - Guide
- If cell contains date then return value ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If two cells match return value from third excel ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 12, 2012 at 10:08 PM
Jan 12, 2012 at 10:08 PM
there is a logical problem
A2 is available in B4 ok
but your condition is
quote
from the row in which A1 was found.
unquote
then in text 2 is in the second row and NOT in the fourth row.
If necessary change the logic
in D1 type this fo=formula or copy paste
=IF(COUNTIF($B$1:$B$5,A1)>0,C1,"")
and copy D1 down.
A2 is available in B4 ok
but your condition is
quote
from the row in which A1 was found.
unquote
then in text 2 is in the second row and NOT in the fourth row.
If necessary change the logic
in D1 type this fo=formula or copy paste
=IF(COUNTIF($B$1:$B$5,A1)>0,C1,"")
and copy D1 down.
