Which LOOKUP formula is used?

[Nanaia]

What LOOKUP formula would I use to look at column B and tell me if there's a matching number in column E. B is not in numerical order but E is. I have tried several different variations of different LOOKUP formulas but none of them seem to work and I can't figure out what I'm doing wrong.

 

[AhoyNC]

Maybe one of these.

Excel Workbook
	A	B	C	D	E
1		45	FALSE	FALSE	1
2		89	FALSE	FALSE	5
3		12	TRUE	TRUE	12
4		65	TRUE	TRUE	34
5		34	TRUE	TRUE	55
6		89	FALSE	FALSE	65
7		100	FALSE	FALSE	70
8		88	TRUE	TRUE	75
9					88
10					101
Sheet

 

[Nanaia]

Never mind. I figured it out. When I formatted the cells to be numbers, for some reason the cell was formatted right but the number within it wasn't? (figure THAT one out). I converted all cells to numbers and my formula worked.
Thanks for your help!