VLookUp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SMH - 04 Mar 2008 15:53 GMT

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!!

Reply to this Message

Mike H - 04 Mar 2008 16:21 GMT

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

> 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.
[quoted text clipped - 6 lines]
>
> Any assistance you can provide would be appreciated!!

Reply to this Message