View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LiveUser LiveUser is offline
external usenet poster
 
Posts: 90
Default Help with this formula

What am I doing wrong?
I know I have to do control shift enter for an array but I am receiving an
error saying my formula is wrong. Can I even so this?


Thank you.

=IF(ISNA(vlookup($B20,Belgium07ComplaintQ4,{4,5,6, 7,8,9,10,11,12,13},0),"",vlookup($B20,Belgium07Com plaintQ4,{4,5,6,7,8,9,10,11,12,13},0)))