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

Would you like to explain that in a bit more detail, please?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chey" wrote in message
...
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

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