Excel - Conditional display of data

December 2016


I am trying to find a way to perform the following without Macro but met with much difficulty.
  • If Cell A1=Any value available in Column B (e.g. B3), Cell A2 would display corresponding value shown in Column C of the same row (e.g. C3).


Use the following formula in A2:
  • =VLOOKUP(A1,B:C,2) 
  • Or you can use this one:
  • =IF(ISERROR(VLOOKUP(A1,B:C,2,0)),"",VLOOKUP(A1,B:C,2,0)) 

Related :

This document entitled « Excel - Conditional display of data » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.