Thread: VLOOKUP
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default VLOOKUP

You could use conditional formatting to highlight a cell in column A
if it is not contained anywhere in column B - is that what you want?
Alternatively, you could have a formula in column C which is copied
down and would return, say, "yes" if the cell does have a match and
"no" if it doesn't, so that you could then apply autofilter to column
C to select either the Yes or the No cells.

Or you could do both.

Are any of these approaches what you want to do?

Pete

On Jun 17, 11:46*am, Rajhans
wrote:
Hi,
Please find the excel sheet entry as below.I need to find whether the values
in coloumn A is available in the coloumn B or not.Presisaly,i need to find
out that which cell entry is not available in coloumn B.How can it be done by
VLOOKUP or other way.
Many Thanks in advance.
Raj