Link to home
Start Free TrialLog in
Avatar of RWayneH
RWayneHFlag for United States of America

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.
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Your question is not clear.

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.
Avatar of RWayneH

ASKER

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

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?
SOLUTION
Avatar of Norie
Norie

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

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

Open in new window

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RWayneH

ASKER

Thanks for the help.