Link to home
Create AccountLog in
Avatar of jjxia2001
jjxia2001

asked on

lookup function in Excel

I need find the word in A Column if B Column is equal to "TRUE".  

=Lookup("TRUE", B1:B3, A1:A3) is not working.  I expect to get "Higher Third".   Help is needed.


        A                             B
1 Higher Third      TRUE
2 Middle Third      FALSE
3 Lower Third      FALSE
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jjxia2001
jjxia2001

ASKER

Works and thanks!