Use VLOOKUP Command to find sales m
Sales Managers Sales message appears, resolve it by
Mike Zhang 4502
Sally Bui 3400 Sales Managers
Ammy Betts 1762 Nicholas Fernandes
Neal Forrest 2500 Karl Johnes
Peter Khan 4210 Tina Carlton
Natasha Song 1232 Smitha Janes
Nicholas Fernandes 4910 Yvette Biti
Phoebe Gour 3910 Jospeh Finch
Preston Senome 2110
Radhya Staples 1700
Samantha Chairs 900
Stevie Bacata 2300
Tina Carlton 4410
Yvette Biti 810
George Bailey 2810
Michael Clarke 1810
Katie Noll 1910
Aaron Finch 3871
Brad Haddin 4121
LOOKUP Command to find sales made by listed sales managers. In case error
message appears, resolve it by putting message "Not in the list"
Sales (Results by using
Sales (Results by using simple IFERROR with VLOOKUP
VLOOKUP Command Command
Fernandes
First Last Marks
Mike Zhang 52
Sally Bui 50
Ammy Betts 74
Neal Forrest 69
Peter Khan 94
Natasha Song 54
Nicholas Fernandes 58
Phoebe Gour 55
Preston Senome 82
Radhya Staples 91
Samantha Chairs 89
Stevie Bacata 53
Tina Carlton 89
Yvette Biti 63
George Bailey 55
Michael Clarke 75
Katie Noll 55
Aaron Finch 61
Brad Haddin 86
Example - 1
Original date Final Output
3/5/2024 Mar 03 2024
3/5/2024 Tuesday 03 March, 2024
3/5/2024 Tuesday
3/5/2024 3-Mar-24
Example - 2
Original text Final Output
3.14872341 3.14
SUBSTITUTE FUNCTION
Sr. No. Sales Data
1 $450
2 $512
3 $509
FIND & SEARCH Function
My name is Sohan Mehra
My name is Sohan Mehra
Name Productivity Scores
Zhang 52
Bui 50
Betts 74
Forrest 69
Khan 94
Song 54
Fernandes 58
Gour 55
Senome 52
Staples 91
Chairs 89
Bacata 53
Carlton 89
Biti 63
Bailey 52
City
SydneyÅ
Winnipeg›
Sydneyœ
MontrealŸ
Sydneyð
OttawaÆ
SydneyÇ
SydneyÈ
MontrealÉ
Ottawañ
Jan Feb Mar Apr May Jun
2000 187 223 36 1495 1475 1981
2001 347 668 321 231 378 147
2002 332 518 186 448 814 366
2003 298 584 286 118 188 70
2004 882 2099 1217 882 299 1217
2005 340 540 200 1388 238 850
2006 388 647 259 639 198 1359
2007 131 284 153 337 553 216
2008 184 288 104 216 385 169
2009 639 198 1359 24 126 102
2010 245 389 144 239 426 187
2011 1204 309 432 419 1023 604
2012 1345 210 320 365 598 233
2013 340 540 200 109 260 151
2014 533 860 327 1321 1429 1520
2015 229 358 129 188 314 126
2016 352 558 206 146 357 211
2017 2218 1488 1322 93 148 55
2018 340 540 200 1111 1984 873
2019 94 208 114 276 438 162
2020 1266 1500 1700 410 931 521
2021 259 398 139 153 247 94
2022 226 358 132 348 543 195
2023 87 181 1300 239 426 187
Jul Aug Sep Oct Nov Dec
882 209 1217 193 2100 123
320 1790 1293 533 860 327
2018 354 1523 352 568 216
71 114 43 94 208 114
153 278 125 533 860 327
160 262 102 252 400 148
1500 542 1200 882 124 1217
1111 1984 873 761 1228 467
533 860 327 159 261 102
1432 1932 1421 639 1998 1359
138 54 850 302 342 1295
170 299 1529 761 1228 467
1400 1943 464 1007 90 591
259 398 139 479 1197 718
459 728 269 871 1428 1343
71 114 43 542 345 619
352 558 206 352 568 216
239 426 187 347 668 321
241 371 1421 1007 45 591
2102 1321 83 479 1197 718
90 210 120 882 2099 1217
119 198 79 109 168 59
109 260 151 43 1265 523
1293 1204 1239 252 400 148
Jan Feb Mar Apr May Jun Jul Aug Sep
2020 187 223 36 1495 1475 1981 882 209 1217
2021 347 668 321 231 378 147 320 1790 1293
2022 332 518 186 448 814 366 2018 354 1523
2023 298 584 286 118 188 70 71 114 43
Oct Nov Dec
193 2100 123
533 860 327
352 568 216
94 208 114
