i obviously did i never heard of it and dont know when to use this
details please? i owe you big time

Gary L Brown wrote:
Thought #1) Did you remember to use ctrl-shift-enter?
Thought #2) Try using vlookup and capture the 'not founds' with...
if(Isna(vlookup(...)),"No in other list","")

HTH,
i have tried the cpearson methods and conditional formatting wth colors but i
cant seem to have it working nothig happens..
[quoted text clipped - 4 lines]

can someone help? thank you alot


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1