Posted to microsoft.public.excel.misc

Alfredo Martinez Alfredo Martinez is offline

external usenet poster

Posts: 5

VLOOKUP error

Hello guys:

This formula

=IF(C8+D8+E8=0,"",ROUND(VLOOKUP(AJ8,'Monthly Sales'!A$1:CN$6000,AK8),2))

used to work with all the previous versions. I switched to Excel 2007 and
now I am getting the #VALUE! result.

Can you help?

Many thanks in advance

--
Alfredo Martinez

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
VBA Vlookup Error	Skip Bisconer	Excel Discussion (Misc queries)	1	October 16th 08 08:51 PM
vlookup error	Vlookup not accurate	Excel Discussion (Misc queries)	9	October 5th 06 04:06 PM
vlookup error	Jim	Excel Worksheet Functions	1	January 25th 06 08:49 PM
vlookup error	Micayla Bergen	Excel Discussion (Misc queries)	2	May 27th 05 02:35 AM
vlookup error!!	Samantha	Excel Worksheet Functions	1	April 11th 05 11:02 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us