Formula to return as true or false

In what sense? What would you want to see returned from the formula to trigger a TRUE response? If it's the word "banana", try this:

=INDEX(Table1[Source]:Table1[Source],MATCH(1,($A6=Table1[ID]:Table1[ID])*($B$3=Table1[StartDate]:Table1[StartDate]),0))="Banana"

Since your formula is contained in an INDEX() your formula is returning a value.
To determine if the result is TRUE or FALSE you need to define what value it should be for TRUE (at least).
Over to you...

Like if a match is found, then true, otherwise false? If so, wrap your formula in a IF: =IF(iserror(your formula),"false","true")

I think that you want to check if these two are match: =IF(AND(VLOOKUP($A21,Table1[ID]:Table1[ID],1,0),VLOOKUP($B$15,Table1[StartDate]:Table1[StartDate],1,0)),"True","False")

A #REF error on a VLOOKUP suggests you are trying to retrieve a column that's beyond the range that is being looked up, e.g.

VLOOKUP(A1,B1:C100,3,0)

returns #REF because the range B1:C100 is only 2 columns wide yet column 3 is trying to be returned.

Check your table ranges, make sure there are 14 and 8 columns to retrieve from the tables respectively.

There's no error trapping in your AND(), the implication is both VLOOKUPs will work which makes the "false" redundant. It will never appear, what will appear is an error on one or more of the VLOOKUPs or the value "true".

#N/A means the value cant be found

#VALUE can mean the lookup exceeds 255 chars
or Full path to the lookup workbook is not supplied

Can you post the data for a thorough check?

I broke up the formula

=IF(VLOOKUP(A6,Table1[ID],1,0),"A","B") returns #VALUE! error

=VLOOKUP(A6,Table1[ID],1,0) returns value from cell A6
so definately something to do with IF formula

Originally Posted by mikehk

I tried ....

=IF(VLOOKUP(A6,Table1[ID],1,0)=FALSE,"a","b") returns b

=IF(VLOOKUP(A6,Table1[ID],1,0)=TRUE,"a","b") returns b

So the data in your Table1[ID] comprises of a list of TRUE or FALSE, though the results from above suggest it's something other than TRUE or FALSE?

Looks like you're only interested in the values being present, not actually what the values are.
Can't you just do a

=IF(AND(NOT(ISNA(VLOOKUP(Calendar!$A21,Table1[Ref]:Table1[Email],14,0))),NOT(ISNA(VLOOKUP(Calendar!$B$15,Table1[Ref]:Table1[Email],8,0)))),TRUE,FALSE)

Attach the workbook, please.

Workbook attached is a good idea.

In the meantime, drawing from the formula from Post#1, try

Formula:

Please Login or Register  to view this content.

	A	B	C	D	E	F	G	H
1	Source	ID	StartDate	EndDate		173	1/21/2019	TRUE
2	Bob	110	1/19/2019	1/22/2019		170	1/26/2019	FALSE
3	John	194	1/24/2019	1/29/2019		159	1/26/2019	FALSE
4	Mike	159	1/18/2019	1/23/2019		106	1/23/2019	TRUE
5	Jacob	173	1/21/2019	1/26/2019
6	Kelly	170	1/22/2019	1/26/2019
7	Martha	159	1/21/2019	1/26/2019
8	Joe	106	1/23/2019	1/28/2019
9	Rachel	135	1/19/2019	1/24/2019
10	Liz	154	1/18/2019	1/22/2019
11