One more quick question. When using the index and match formula you
gave me:

=INDEX(G:G,MATCH(A22,F:F,0)

How do I add if F is not blank?

Thanks again for your help.
Lori


--
LoriM1
------------------------------------------------------------------------
LoriM1's Profile: http://www.excelforum.com/member.php...fo&userid=2815
View this thread: http://www.excelforum.com/showthread...hreadid=532681