![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
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 |
![]() |
zachluke | Excel | 3 | 03-13-2014 11:15 AM |
![]() |
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 |