VLookUp

  • Thread starter Thread starter SMH
  • Start date Start date
S

SMH

I have three tabs within one spreadsheet, Column A holding the same data,
I.E. Last Name. I need to know if the Last Name is found on the other tabs.
Here is the formula I have so far:

=VLOOKUP(A2,DEC!A1:O94,1,TRUE)

Right now the result is not providing a True/False rather the value in
Column A.

Any assistance you can provide would be appreciated!!
 
Hi,

You have 3 worksheets, Tabs are simply used to hold the name and provide
other bits of functionality.

Your formula is returning the value from column 1 of your table array and if
it finds a near match (The true switch) it returns it

Try this instead to return True/False if it finds a match
=COUNTIF(DEC!A1:A44,A2)>0

Mike
 
Back
Top