Thread: matching like numbers/data points residing in different columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_100_] colofnature[_100_] is offline
external usenet poster
  
Posts: 1
Default matching like numbers/data points residing in different columns

So you're saying: you want blanks in col B if they don't appear in co
A?

In B1, put the formula =VLOOKUP($B1,$A:$A,1,0)

then fill down in col B to the bottom and replace all #N?A in col
with blanks


Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=57197

Reply With QuoteReply With Quote