VLookUp
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
"SMH" wrote:
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!!
|