If or lookup Statement

[Chey]

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

 

[Bernard Liengme]

Would you like to explain that in a bit more detail, please?

 

[Mike H]

Maybe

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

Mike