How to use Wingdings in formulae

Hi all,

I am trying to include Wingdings symbols in formulas..
Some VBA cater for ticks and X
Would appreciate a formula fix to include Symbols please.
The attached WB provides example and outcome

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Further to WB Ver D, have been working on the missing parts of the formulae for K10.

Attached is WB ‘Formulae with Symbols-D4’ which contains additional Tab - Sheet1 (4) with following amendments:

No VBA;
Created Named Ranges Expectations__√ and Expectations_X - used in E10, F10, G10 as applicable;
Changed cells in row I24: AF24 to √, √, X (Calibri font);
Changed formulae in K10 to include Match functions for E10,F10,G10;
But I get error “You’ve entered too many arguments etc.and I cannot locate that error.

Hope someone can assist with a fix please.

See if this works for you in F12:

=INDEX($I$26:$AF$29,MATCH(C10,$G$26:$G$29,0),MATCH(F9&A10&F10,$I$23:$AF$23&$I$24:$AF$24&$I$25:$AF$25,0))

Or in E12 copied across:

=INDEX($I$26:$AF$29,MATCH($C$10,$G$26:$G$29,0),MATCH(F$9&$A$10&F$10,$I$23:$AF$23&$I$24:$AF$24&$I$25:$AF$25,0))

The lookup references could, of course, be drop-down boxes.

By the way:

Excel 2016 (Windows) 32 bit

	G	H
10	X	This formula in K10 does not work >>>
11
12	0.75
13
14	No
15	Result
16	with X
17	F10 should
18	be 9.75	WRONG! See N29 …
19	as per
20	N29
21

Sheet: Sheet1

The references are incorrect. In E12 you need this:

=INDEX($I$26:$AF$29,MATCH($C$10,$G$26:$G$29,0),MATCH(E$9&$A$10&E$10,$I$23:$AF$23&$I$24:$AF$24&$I$25:$AF$25,0))

Excel 2016 (Windows) 32 bit

	E
10	v
11
12	1.25
13
14	Works
15	OK
16	eith
17	Tick v
18	in E10
19	matches
20	L29
21

Sheet: Sheet1

Now, explain how you expect this to work, particularly the bit in red:

Expected Outcome in K10 should be a value from below matrix, depending on selection in A10, B10, and one of E10, F10 or G10.

Why B10? There is nothing there. And how is the formula meant to decide between E10, F10 and G10. There's something missing from your requirements - the missing link is what I need, although I suspect the formula I've given you will do what you need if you have drop-downs in certain cells.

OK - I think this might be what you are after in K10:

=IF(COUNTIF($E$10:$G$10,"<>")=1,INDEX($I$26:$AF$29,MATCH($C$10,$G$26:$G$29,0),MATCH(LOOKUP(2,1/($E$10:$G$10<>""),$E$9:$G$9)&$A$10&LOOKUP("zzzzzzzzzzzz",$E$10:$G$10),$I$23:$AF$23&$I$24:$AF$24&$I$25:$AF$25,0)),"")

If not, then you really will need to explain in more detail what you are trying to achieve.

Did you see post #18?

You may need to enter the formula as an array formula if you are still using Excel 2010 (by using CTRL+SHIFT+ENTER instead of just ENTER).

Yes, that is correct. There is nothing selected in the range E10 to G10 - until one of those cells is populated, the formula will not kick in:

Excel 2016 (Windows) 32 bit

	E	F	G
10

Sheet: Sheet1

You said that one of those cells needed to be populated, and with blanks, there will be no match, anyway.

Look at the first section of my formula:

=IF(COUNTIF($E$10:$G$10,"<>")=1, ...

This is nothing to do with maths, by the way. It's not even to do with symbols. It's just logic.

No worries! Please mark the thread as solved.