For example, I have department codes on column A, internal records on column B, and external records on column C. I want to compare what cell values from column C are found on column B, and if found, to return the value from Column A that is on the same row as Column B (to display on another column).
I was able to do the complete opposite of what I needed using this formula:
=if(iserror(vlookup(c1,$b$1:$b$1000,1,false)),a1,"")
I copied this into Column D, but as I thought it displayed the values from Column A for the values that were NOT found on column B.
All help very appreciated.
I was able to do the complete opposite of what I needed using this formula:
=if(iserror(vlookup(c1,$b$1:$b$1000,1,false)),a1,"")
I copied this into Column D, but as I thought it displayed the values from Column A for the values that were NOT found on column B.
All help very appreciated.