Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |