View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
japc90 japc90 is offline
external usenet poster
 
Posts: 58
Default VLOOKUP Formula causing an error


=COUNTIF(B6:E42,"*out")+COUNTIF(B6:E42,"*vac")+VLO OKUP(C50,$H$43:$K$47,4)

I am trying to use the above formula and I keep receiving a #N/A error.
There is currently a cell (C50) where the user will type in a day of
the week. It is supposed to then lookup that day of the week on an
adjacent chart and pull in the number that is located in the cell to
the right of that day. It works for the cells containing Monday -
Thursday, but when Friday is entered it will not work. I have checked
to make sure that the formula contains the correct cell range. It will
also work if I change Friday to anything else unless it is an
abbreviation of Friday then I still receive the above mentioned error.

I am extremely confused.