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
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete columns in word - Guide
- 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
- What function can automatically return the value in cell c77 ✓ - 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.