Please click 'Yes', if the post was helpful to you.

--
RyGuy


"Snailspace" wrote:

YOU ROCK!! That worked! I'm getting where I need to be!

Thanks for your help.



On Mar 17, 2:30 pm, rspowell wrote:
Try something like this ...

=IF(VLOOKUP("My Criteria",A:B,2,FALSE)=0," ",VLOOKUP("My Criteria",A:B,
2,FALSE))

Hope it helps you !

- Rodney POWELL
Microsoft MVP - Excel

www.BeyondTechnology.com