=IF(OR(A22="",ISNA(MATCH(A22,F:F,0))),"",INDEX(G:G ,MATCH(A22,F:F,0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LoriM1" wrote in
message ...

Ok, now my problem reversed itself. I guess I need if F and A are not
blank. I have a blank field in F and now every blank field in A fills
in B with the first corresponding number in G that F shows as blank.


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