Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 355

#VALUE! error when trying to add cells (VLOOKUP)

I am trying to add cells that have been filled with the VLOOKUP function.

=SUM(F6+I6+L6+O6+R6+T6)

Those cells have a value from a VLOOKUP function

=IF(ISNA(VLOOKUP(Q6,Points!$K$5:$L$28,2))," ",VLOOKUP(Q6,Points!$K$5:$L$28,2))

If there is nothing in one of the cells I get the #VALUE! error (it works if
there is a number there). What am I doing wrong?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP #N/A Error	NM	Excel Worksheet Functions	7	November 13th 08 09:41 PM
VLOOKUP ERROR	DeVoe	Excel Worksheet Functions	3	April 11th 07 09:11 PM
Vlookup value not available error	[email protected]	Excel Discussion (Misc queries)	1	December 30th 06 09:44 PM
vlookup error	Vlookup not accurate	Excel Discussion (Misc queries)	9	October 5th 06 04:06 PM
vlookup error	Vlookup not accurate	Excel Discussion (Misc queries)	0	October 4th 06 06:21 PM

All times are GMT +1. The time now is 04:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us