You're welcome. Thanks for the feedback!

Biff

"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:6c8a21e637745@uwe...
You jare the best!!

T. Valko wrote:
I'm guessing that you don't want #N/A?

This will leave those cells blank:

=IF(ISNA(VLOOKUP(D11, 'Pay Rate'!$D$2:$E$8, 2)),"",VLOOKUP(D11, 'Pay
Rate'!$D$2:$E$8, 2))

Biff

I am copying down my formula and in areas that i don't have any data the
result is N/A
[quoted text clipped - 3 lines]
thanks
for your help

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