Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Vlookup and If Statements
Hey everyone, I'm stuck with this formula: =IF(C7="Ireland",VLOOKUP(A7,Data_Ireland,2,FALSE), IF(C7="Regions",VLOOKUP(A7,Data_Regions,2,FALSE),I F(C7="Corporate",VLOOKUP(A7,Data_Corporate,2,FALSE ),"") 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: http://www.excelforum.com/member.php...o&userid=31333 View this thread: http://www.excelforum.com/showthread...hreadid=510137 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Vlookup and If Statements
Tricking to tell without seeing the data but try adding another ) to the end
of the formula. "SunnyM" wrote: Hey everyone, I'm stuck with this formula: =IF(C7="Ireland",VLOOKUP(A7,Data_Ireland,2,FALSE), IF(C7="Regions",VLOOKUP(A7,Data_Regions,2,FALSE),I F(C7="Corporate",VLOOKUP(A7,Data_Corporate,2,FALSE ),"") 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: http://www.excelforum.com/member.php...o&userid=31333 View this thread: http://www.excelforum.com/showthread...hreadid=510137 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Vlookup and If Statements
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, {"Ireland","Regions","Corporate"},0),Data_Ireland, Data_regions,Data_corporate),2,FALSE) -- Kevin Vaughn "sp3cialist" wrote: Tricking to tell without seeing the data but try adding another ) to the end of the formula. "SunnyM" wrote: Hey everyone, I'm stuck with this formula: =IF(C7="Ireland",VLOOKUP(A7,Data_Ireland,2,FALSE), IF(C7="Regions",VLOOKUP(A7,Data_Regions,2,FALSE),I F(C7="Corporate",VLOOKUP(A7,Data_Corporate,2,FALSE ),"") 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: http://www.excelforum.com/member.php...o&userid=31333 View this thread: http://www.excelforum.com/showthread...hreadid=510137 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Vlookup and If Statements
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: http://www.excelforum.com/member.php...o&userid=31333 View this thread: http://www.excelforum.com/showthread...hreadid=510137 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Vlookup and If Statements
I've seen it used here (in this newsgroup,) so decided to see if I could get
it to work, and I could. -- Kevin Vaughn "SunnyM" wrote: 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: http://www.excelforum.com/member.php...o&userid=31333 View this thread: http://www.excelforum.com/showthread...hreadid=510137 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I use =if with vlookup statements | Excel Worksheet Functions | |||
Vlookup and if statements | New Users to Excel | |||
VLOOKUP + IF STATEMENTS | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
VLOOKUP statements | Excel Discussion (Misc queries) |