Need to find a value in a column

[InterstateRentals]

We have a table that has a value that we are interested in that is always in the cell next to that value.

The example sheet will help with this explanation.

We want to go to this table and find the Customer in Column B that matches 8H. Then we want to find their account number, which is always to the left by one cell. So in this case, we want it to find OIO898 in cell A12.

Any help please without macros!?

Thank you!

[martindwilson]

=INDEX($A$5:$A$20,MATCH("8h",$B$5:$B$20,0))
or replace the"8h" with a cell ref containing 8h
eg with 8H in cell X1
=INDEX($A$5:$A$20,MATCH(x1,$B$5:$B$20,0))

[FDibbins]

Try this, based on your sample data...
=INDEX($A$5:$A$20,MATCH("8H",$B$5:$B$20,0))

edit: is there an echo in here, Martin?

[TMS]

=INDEX(A:A, MATCH("8H", B:B, 0))

Regards, TMS

[Richard Buttrey]

Hi,

See attached

[InterstateRentals]

You guys are nothing short of AWESOME! Thank you sooooo much. It is cool to see duplicate solutions, just proves that y'all have those genius minds that work alike!

Again, we really really appreciate the help with these troublesome problems ... and we love it when they get solved!

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[FDibbins]

Thanks for the kind words and the feedback