RWayneH

asked on

# 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)

Please advise and thanks.

=VLOOKUP(LEFT(A5,9),Sheet1

Please advise and thanks.

ASKER

Lets make it easier.

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

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

ASKER

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?

=IF(ISNA(VLOOKUP(A1,Highli

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

SOLUTION

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")`

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks for the help.

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.