Try...
=IF(J2<>"",VLOOKUP(J2,RATE!$A$1:C$20,IF(I2="P",2,3),FALSE),"")
Hope this helps!
In article <nowfal.1uncyk_1125522348.1684@excelforum-nospam.com>,
nowfal <nowfal.1uncyk_1125522348.1684@excelforum-nospam.com> wrote:
> Hi Gord Dibben,
> This is the formula i am getting error message if the cell 'J' is
> empty, and the formula is in 'L'
> =VLOOKUP(J2,RATE!$A$1:C$20,IF(I2="P",2,3),FALSE)
> So how to correct it.
> thanks and regards
> nowfal
Bookmarks