Prev Previous Post   Next Post Next
  #1   Report Post  
Brian
 
Posts: n/a
Default #NA

I have a VLOOKUP that checks the information of 2 cells against a table to
determine the proper information to be displayed. It works fine except when
there is not any information yet placed in the cells. The that #NA shows up
when I just want it to be blank. I tried the ISNA, but I think I am doing
something wrong because I am getting the Error "You Have Entered Too Many
Arguments For This Function"

Here is my function. What am I doing wrong?
=IF(ISNA($B12<$O$12,VLOOKUP(C12,$K$14:$O$18,4,FALS E)),"",VLOOKUP(C12,$K$14:$O$18,5,FALSE))

It works fine if I remove the (ISNA and the ),"" piece.
Help me
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"