Thread: VLOOKUP problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default VLOOKUP problem

In C1: =IF(ISERROR(VLOOKUP(B1,A:A,1,FALSE)),"","FOUND")
and copy down column C.

Hope this helps,

Hutch

"GKW in GA" wrote:

I have a .xls file in which column A and column B are formatted identically,
All entries that are in coumn B are in column A but there are entries in col
A that are not are in col B, i.e. col B is a subset of col A. For every entry
in column A that exists in col B, I want to place "found" in col C of the
same row as A. How can I do this with VLOOKUP