Excel help

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I have four columns of data.
Column B is a list of words that match up with the words in column C. However column B is a complete list and column C only a partial list. The words in column C correspond to numbers in column D that appear on the same row. Using the formula=IF(ISNUMBER(MATCH(B2,C:C,0)),B2,"") I now have columns B and C lined up with blanks in column C where there are missing values. How do I make column D reflect the same blanks as column C?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
use this formula

the number of rows in my sample sheet is 10 if you have more modify the formula suitably

=IF(ISNA(INDEX($D$2:$D$10,MATCH(E2,$C$2:$C$10),1)),"",INDEX($D$2:$D$10,MATCH(E2,$C$2:$C$10)))