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
- Excel compare two columns for partial matches - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Comparing columns in two different excel sheets and if they match copying third column - Excel Forum
1 reply
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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.
