software

Hey everyone,

I'm stuck with this formula:

=IF(C7=quot;Irelandquot;,VLOOKUP(A7,Data_Ireland,2,FALSE), IF(C7=quot;Regionsquot;,VLOOKUP(A7,Data_Regions,2,FALSE),I F(C7=quot;Corporatequot;,VLOOKUP(A7,Data_Corporate,2,FALSE ),quot;quot;)

I've spent 4 hours on it trying to get it to work but it keep telling
me i'm missing a parenthesis. So after 4 hours of being in the same
situation as i started i've decided to ask the experts, Any ideas
anyone?

Thanks for all your help with this it's very much appreciated,

Sunny--
SunnyM
------------------------------------------------------------------------
SunnyM's Profile: www.excelforum.com/member.php...oamp;userid=31333
View this thread: www.excelforum.com/showthread...hreadid=510137Tricking to tell without seeing the data but try adding another ) to the end
of the formula.

quot;SunnyMquot; wrote:

gt;
gt; Hey everyone,
gt;
gt; I'm stuck with this formula:
gt;
gt; =IF(C7=quot;Irelandquot;,VLOOKUP(A7,Data_Ireland,2,FALSE), IF(C7=quot;Regionsquot;,VLOOKUP(A7,Data_Regions,2,FALSE),I F(C7=quot;Corporatequot;,VLOOKUP(A7,Data_Corporate,2,FALSE ),quot;quot;)
gt;
gt; I've spent 4 hours on it trying to get it to work but it keep telling
gt; me i'm missing a parenthesis. So after 4 hours of being in the same
gt; situation as i started i've decided to ask the experts, Any ideas
gt; anyone?
gt;
gt; Thanks for all your help with this it's very much appreciated,
gt;
gt; Sunny
gt;
gt;
gt; --
gt; SunnyM
gt; ------------------------------------------------------------------------
gt; SunnyM's Profile: www.excelforum.com/member.php...oamp;userid=31333
gt; View this thread: www.excelforum.com/showthread...hreadid=510137
gt;
gt;

It really is as simple as that. However, to get your full money's worth, I
created an alternative formula for you (the original poster (oh, that's where
they get OP from!)

=VLOOKUP(A7, CHOOSE(MATCH(C7,
{quot;Irelandquot;,quot;Regionsquot;,quot;Corporatequot;},0),Data_Ireland, Data_regions,Data_corporate),2,FALSE)
--
Kevin Vaughnquot;sp3cialistquot; wrote:

gt; Tricking to tell without seeing the data but try adding another ) to the end
gt; of the formula.
gt;
gt; quot;SunnyMquot; wrote:
gt;
gt; gt;
gt; gt; Hey everyone,
gt; gt;
gt; gt; I'm stuck with this formula:
gt; gt;
gt; gt; =IF(C7=quot;Irelandquot;,VLOOKUP(A7,Data_Ireland,2,FALSE), IF(C7=quot;Regionsquot;,VLOOKUP(A7,Data_Regions,2,FALSE),I F(C7=quot;Corporatequot;,VLOOKUP(A7,Data_Corporate,2,FALSE ),quot;quot;)
gt; gt;
gt; gt; I've spent 4 hours on it trying to get it to work but it keep telling
gt; gt; me i'm missing a parenthesis. So after 4 hours of being in the same
gt; gt; situation as i started i've decided to ask the experts, Any ideas
gt; gt; anyone?
gt; gt;
gt; gt; Thanks for all your help with this it's very much appreciated,
gt; gt;
gt; gt; Sunny
gt; gt;
gt; gt;
gt; gt; --
gt; gt; SunnyM
gt; gt; ------------------------------------------------------------------------
gt; gt; SunnyM's Profile: www.excelforum.com/member.php...oamp;userid=31333
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=510137
gt; gt;
gt; gt;


thanks Lads much appreciated, have read up on the choose function and
didn't realise the function existed,

thanks again you guys much appreciated--
SunnyM
------------------------------------------------------------------------
SunnyM's Profile: www.excelforum.com/member.php...oamp;userid=31333
View this thread: www.excelforum.com/showthread...hreadid=510137I've seen it used here (in this newsgroup,) so decided to see if I could get
it to work, and I could.
--
Kevin Vaughnquot;SunnyMquot; wrote:

gt;
gt; thanks Lads much appreciated, have read up on the choose function and
gt; didn't realise the function existed,
gt;
gt; thanks again you guys much appreciated
gt;
gt;
gt; --
gt; SunnyM
gt; ------------------------------------------------------------------------
gt; SunnyM's Profile: www.excelforum.com/member.php...oamp;userid=31333
gt; View this thread: www.excelforum.com/showthread...hreadid=510137
gt;
gt;