Formula to compare 2 columns and enter letters in a 3rd column if the 2 columns match

**jessie.black** · 09-21-2016, 03:38 PM

These have potential!!! Thank you! The order of them is a little mixed up because the list of schools (in column B and N) do not start until row 4. How do I adjust the formula?

**Tony Valko** · 09-21-2016, 04:21 PM

Originally Posted by jessie.black

list of schools (in column B and N) do not start until row 4. How do I adjust the formula?

Like this...

=IF(COUNTIF(N$4:N$20,B4),"NIR","")

Adjust for the correct end of range where I've used N$20.

Formula to compare 2 columns and enter letters in a 3rd column if the 2 columns match

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Formula to compare 2 columns and enter letters in a 3rd column if the 2 columns match

Re: Formula to compare 2 columns and enter letters in a 3rd column if the 2 columns match

Thread Information

Users Browsing this Thread

Similar Threads

Compare 2 columns and if they match return a price from a 3rd column

compare 2 columns if same lookup 3rd column and enter that data

compare two columns and return match from third column

[SOLVED] Compare 2 columns for a match and populate a 3rd column with a value where one exists.

Compare 2 different columns based on 1 result and match all results in column 2

Match info in 2 columns, find and add data from third column and enter in a cell total

[SOLVED] Compare 2 columns and choose one and enter answer in third column

Bookmarks

Bookmarks

Posting Permissions