View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tipoo tipoo is offline
external usenet poster
 
Posts: 15
Default Matching two numeric values

Hi,

I have two sheets. I want to show in sheet 2 column B values in sheet 2
column A that match from column E sheet 1 and if they do not exist in sheet 1
column E then say do not exist and that cell in red colour.

Sheet 1 Sheet 2
Column E Column A Column B
1233 4875
1355 5875
4875 1355


Thanks