How To Convert Words and Names To Values in Numbers With IF, SWITCH and LOOKUP
macmostvideo macmostvideo
383K subscribers
20,137 views
0

 Published On Dec 2, 2022

https://macmost.com/e-2837 If you have names, product IDs or some other words and need to translate those to number values you can do it with the IF, IFS, SWITCH or LOOKUP functions in Numbers. While the first functions are good for small limited lists of values, only the LOOKUP function works well with a large list that changes often.

FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ YouTube — http://macmost.com/j-youtube (And hit the 🔔)
▶︎ YouTube Email Notifications — http://macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter — https://macmost.com/newsletter ✉️

SUPPORT MACMOST AT PATREON
▶︎ https://macmost.com/patreon ❤️

00:00 Intro
01:05 The IF Function
03:44 Nested IF Functions
05:26 The IFS Function
06:29 The SWITCH Function
08:18 The LOOKUP Function

#macmost #mactutorial #numbers

show more

Share/Embed