Explanation for this formula

		Microsoft Office Forums > Microsoft Excel > Excel
Explanation for this formula

FAQ

Thread Tools

Display Modes

11-26-2014, 06:28 AM

Bruno Campanini Bruno Campanini is offline

Windows 8

Office 2013

Novice

Join Date: Nov 2014

Posts: 19

Bruno Campanini is on a distinguished road

Quote:

Originally Posted by Will

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) ))

This is a bad formula (see my previous post).

Try this one, it's simple and more reliable:

=(IF(ISERROR(MATCH(A1,$E$1:$E$10,0)),"Another Value",A1))

Bruno

Last edited by macropod; 11-26-2014 at 05:25 PM. Reason: Repaired messed up QUOTE tagging

« Previous Thread | Next Thread »

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
Need help with formula	zachluke	Excel	3	03-13-2014 11:15 AM
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 11:31 PM.