formula to return a certain Time Zone depending upon country user inputs
Last edited by VBA Noob; 07-31-2008 at 06:18 AM.
Your VLOOKUP is flawed because you can't return a value from the 3rd column of a single column range....also I presume ¶ would normally be ,
Try this version
=IF(A3="","",IF(ISNA(VLOOKUP(A3,'K:\Keith McIntyre\Documentation\[Siebel_Time_Zone_Master.xlsx]Sheet1'!$A$2:$B$699999,2,0)),"Time Zone Not Found",VLOOKUP(A3,'K:\Keith McIntyre\Documentation\[Siebel_Time_Zone_Master.xlsx]Sheet1'!$A$2:$B$699999,2,0)))
Do you really have 699999 rows in your table?
Thanks Mate! That works perfectly!!!
No i don't have 699999 rows, but i set it to that just incase i ever went down that far.
Also the reason my seperators are ¶ instead of , is because i've changed this in the default Windows options.
Many Thanks Again
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1