Posted to microsoft.public.excel.programming

amirstal[_2_] amirstal[_2_] is offline

external usenet poster

Posts: 18

MAXA won't work with VLOOKUP?

Using vlookup, A1 returns 09/18/2008 while B1 returns 09/17/2008. When
I apply C1=MAXA(A1,B1) I am getting zero instead of 09/18/2008. Doing
the same thing to A1 and B1 but not using vlookup returns the correct
value (09/16/2008). Is there a way to make MAXA work with vlookup?

Thanks,

Amir

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
Using =MAX() or =MAXA() on Pivot results doesn't work	circuit_breaker	Excel Worksheet Functions	1	July 13th 09 06:46 PM
excel maxa	Harry	Excel Discussion (Misc queries)	5	June 30th 08 08:37 PM
MAX, MAXA functions	Dave F[_2_]	Excel Discussion (Misc queries)	3	March 28th 08 05:57 PM
MAX & MAXA returning 0 value	-Rocket	Excel Discussion (Misc queries)	6	March 19th 07 05:31 PM
Countif, Maxa or other function?	jacobk	Excel Worksheet Functions	2	April 1st 06 06:20 AM

All times are GMT +1. The time now is 10:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us