This is tricky to explain but I will try my best. There is a long list of schools in column B. In column N, there is a shorter list of some of the schools. I need to know a way to cross reference the schools in column N with the schools in column B. If they match, I need to put "NIR" in column C, in the same row. Please let me know if this is clear. Thank you!!!
try this in column C
=IF(ISERROR(VLOOKUP(B1,N:N,1,0)),"","NIR")
This formula is taking information in Column B and seeing if it is in column N.
Try
in C2
=IFERROR(IF(MATCH(B2,$N$2:$N$1000,0),"NIR",""),"")
Copy down
One way...
Data Range
This formula entered in C2 and copied down:
=IF(COUNTIF(N$2:N$6,B2),"NIR","")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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?
=if(iserror(vlookup(b4,n:n,1,0)),"","nir")
Like this...Originally Posted by jessie.black
=IF(COUNTIF(N$4:N$20,B4),"NIR","")
Adjust for the correct end of range where I've used N$20.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks