?
Solved

lookup function in Excel

Posted on 2014-01-03
2
Medium Priority
?
316 Views
Last Modified: 2014-01-03
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
0
Comment
Question by:jjxia2001
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 800 total points
ID: 39754808
LOOKUP needs column B to be listed in alphabetic ascending order for that to work....

Try:

=INDEX(A1:A3,MATCH(TRUE,B1:B3,0))

or

=INDEX(A1:A3,MATCH("TRUE",B1:B3,0))

depending on how TRUE is entered in the cells.
0
 

Author Closing Comment

by:jjxia2001
ID: 39754826
Works and thanks!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question