# VLOOKUP.. that uses T/F values

using a vlookup.  Is there a way to chg the formula to say something like.  If true, put a "Y" and the cell and if false put an "N" in the cell?

=VLOOKUP(LEFT(A5,9),Sheet1!A:B,2,FALSE)

Subodh Tiwari (Neeraj)

Do you want to place a Y in the formula cell if LEFT(A5,9) is found in column A of Sheet1 and a N if it is not found?

Would help if you can upload a sample workbook with desired output filled manually.

Lets make it easier.
=VLOOKUP(A5),Sheet1!A:B,2,FALSE)  If True = Y and if False = F

I have

=IF(ISNA(VLOOKUP(A1,HighlightRangeOrInsertNamedRange,1,FALSE)),"Whatever text you want here",VLOOKUP(A1, HighlightRangeOrInsertNamedRange,1,FALSE))

but it only covers the if N/A or False side,  how do we add the true piece?
SOLUTION
Norie

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So your original formula will become like this....

``=IF(ISNA(VLOOKUP(LEFT(A5,9),Sheet1!A:B,2,FALSE)),"N","Y")``

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.