Previous Topic Next Topic

Excel help

Closed
kl - Jul 6, 2009 at 03:15 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 6, 2009 at 09:33 PM
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

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 6, 2009 at 09:33 PM
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)))
0