Maybe

=VLOOKUP(A7,L7:M153,2,FALSE)

Mike

"Chey" wrote:

I want to write an if or a Lookup statement in a cell that if anything is the
range of example (L7:L153)=(A7), the number next to the cell that matches.



Thanks
Cheyenne