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