| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup Encounters a call with no data and returns #N/A
My vlookup formula goes like this
=VLOOKUP($A2,December!$C$3:$H$68,3,FALSE)+VLOOKUP( $A2,January!$C$3:$H$65,3,FALSE)+VLOOKUP($A2,Februa ry!$C$3:$H$74,3,FALSE)+VLOOKUP($A2,March!$C$3:$H$8 5,3,FALSE)+VLOOKUP($A2,April!$C$3:$H$85,3,FALSE) The formula finds a name an adds the numbers associated with that name in the cells together, but some of the months like April do not have the names of the people so the vlookup returns #N/A instead of the sum, because that name could not be found in the specified tab labeled March or April. What kind of IF Statement can i use to continue adding the cells even if that persons name dosen't show up in that tab. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call a Visual Basic Function with VLookup | Excel Worksheet Functions | |||
| Vlookup Returns Wrong/No Data | Excel Worksheet Functions | |||
| VLookup occasionally returns formula with no data | Excel Discussion (Misc queries) | |||
| vlookup returns bad data | Excel Worksheet Functions | |||
| VLOOKUP Returns Erroneous Value When Control Data is Variable | Excel Worksheet Functions | |||
Threaded Mode
