Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-25-2014, 09:14 AM
Will Will is offline Explanation for this formula Windows XP Explanation for this formula Office 2007
Novice
Explanation for this formula
 
Join Date: Oct 2011
Posts: 5
Will is on a distinguished road
Default Explanation for this formula

Hi,

I was searching on-line for some help on the Find formula, and came across this. Would someone be able to explain it?



=LOOKUP(REPT("z",255),CHOOSE({1,2},"ANOTHER VALUE",LOOKUP(1000,FIND($E$1:$E$10,A1),$E$1:$E$10) ))

There were a list of values in cells E1:E10.
There were a list of inputs in A1 downwards.
What was wanted was a formula which gave, for each input in A1 downwards, one of the values in E1:E10 if an input in A1 downwards contained one of those values, and if not then it returned "Another Value".

It works but I can't work out how or why!

For example:-
(1) the second LOOKUP includes FIND($E$1:$E$10,A1) but on its own this formula just returns #VALUE.
(2) what do the {} mean within the CHOOSE formula? I assume these are not to do with an array?

Many thanks,

Will
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
where to find explanation of reference styles LMHmedchem Word 5 07-22-2014 09:24 PM
Formula muhu Excel 1 04-14-2014 08:19 AM
Explanation for this formula Need help with formula zachluke Excel 3 03-13-2014 11:15 AM
Explanation for this formula Explanation for fields on the form hklein Word VBA 5 10-23-2011 04:10 AM
Microsoft Office XP/2003/2007/2010 Graphic Filters "Allow List" Explanation Jazz43 Office 0 08-24-2011 10:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft