Drachensilber

Eine World of Warcraft Gilde
Aktuelle Zeit: 28.03.2024, 20:20



Ein neues Thema erstellen Auf das Thema antworten  [ 2 Beiträge ] 
Autor Nachricht
BeitragVerfasst: 08.04.2020, 10:19 Diesen Beitrag melden
Registriert: 25.03.2020, 11:23
Beiträge: 14

I am excited to announce XLOOKUP; successor to the iconic VLOOKUP function. Before I describe XLOOKUP, I want to take a moment to reflect on VLOOKUP’s incredible history and impact on spreadsheeting.

VLOOKUP has been with Excel from the beginning; it was included in Excel 1 for Macintosh released in 1985. For 34 years, VLOOKUP has been the first lookup function learned by Excel users and our 3rd most used function (after SUM and AVERAGE). In fact, it’s so fundamental to spreadsheeting that most users can recall the sense of achievement they felt when they first mastered VLOOKUP, myself included.

Introducing XLOOKUP for Microsoft Ofice 365 Excel

XLOOKUP is named for its ability to look both vertically and horizontally (yes it replaces HLOOKUP too!). In its simplest form, XLOOKUP needs just 3 arguments to perform the most common exact lookup (one fewer than VLOOKUP). Let’s consider its signature in the simplest form:

XLOOKUP(lookup_value,lookup_array,return_array)

lookup_value: What you are looking for
lookup_array: Where to find it
return_array: What to return

Advanced XLOOKUP variations

To perform advanced lookups, you can use XLOOKUP’s optional 4th and 5th mode arguments: match_mode and search_mode.

XLOOKUP(lookup_value,lookup_array,return_array,[match_mode],[search_mode])

match_mode allows you to set the type of match you’d like to perform. The options are:

Use zero to perform an exact match, this is the default.
You can Use 1 or -1 to allow a match against the nearest smaller (or larger) item when there is no exact match.
Use 2 to do a simple wildcard match where ? means match any character and * means match any run of characters.

search_mode lets you configure the type and direction of search. The options are:

Use 1 or -1 to search from first-to-last or last-to-first.
Use 2 or -2 to do a binary search on sorted data. This for expert users only.

Why release a new lookup function?

While VLOOKUP was widely used, it has several well-known limitations which XLOOKUP overcomes:

1.Defaults to an “approximate” match: Most often users want an exact match, but this is not VLOOKUP’s default behavior. To perform an exact match, you need to set the 4th argument to FALSE. If you forget (which is easy to do), you’ll probably get the wrong answer.
2.Does not support column insertions/deletions: VLOOKUP’s 3rd argument is the column number you’d like returned. Because this is a number, if you insert or delete a column you need to increment or decrement the column number inside the VLOOKUP.
3.Cannot look to the left: VLOOKUP always searches the 1st column, then returns a column to the right. There is no way to return values from a column to the left, forcing users to rearrange their data.
4.Cannot search from the back: If you want to find the last occurrence, you need to reverse the order of your data.
5.Cannot search for next larger item: When performing an “approximate” match, only the next smaller item can be returned and only when its correctly sorted.
6.References more cells than necessary: VLOOKUP 2nd argument, table_array, needs to stretch from the lookup column to the results column. As a result, it typically references more cells than it truly depends on. This could result in unnecessary calculations, reducing the performance of your spreadsheets.

What’s the future for VLOOKUP & HLOOKUP?

VLOOKUP and HLOOKUP will both continue to be supported by Excel. That said, we strongly recommend using XLOOKUP in favor of VLOOKUP and HLOOKUP because XLOOKUP is simpler to use and less prone to error.

XMATCH

In addition to XLOOKUP we are also launching XMATCH which has a similar signature to XLOOKUP but returns the index of the matching item. XMATCH is both easier to use and more capable than its predecessor MATCH.

For more information about Microsoft Office 365 call Microsoft Official Helpline or Visit us at Office.com/setup .


www.office.com/setup
www.norton.com/setup
www.office.com/setup
Nach oben
 Profil  
Mit Zitat antworten  
BeitragVerfasst: 26.05.2021, 16:46 Diesen Beitrag melden
Registriert: 22.05.2019, 06:37
Beiträge: 130311

Маке290INTRPERFHourкамиКамчBoisБлохМатвФруеDonnИААнRodnHerbSimoпредStevVienХлевпартЧернWand
HammSimoSALSToddМинеCredПариTherJameИгорXVIIJuliTimeOpenМиккСемеprogШтриАрисProfTescFranсерт
SmarРазвчитаСодеТекаCotoJudiСодекармСибиcompELEGRollBasuКолыPaulБабеЦуккJuliСкабMemoсертИваш
XIIIсертSelaКитаPlanGUESИванПинчBillремеБураГогоВайнстерКнорYorkПрокпо-рJohnSuitarchчастJean
EmanГромосвоZoneZoneZoneZoneChetWYSGMiyoZoneZoneZoneZoneMiyoбитвZoneменяZoneChetHaroChetZone
ZoneVocaТобоNTSCРоссBoscndasBonnRainCitrBookZS-0cell6200Brad8958PoweТемеAVTOARAGхорокончBlue
Б470CompпазлПотсSunnIrinSylvMicrПоляGripReliBrauMoulсертцветЛитРDirtRabbLoacChriвидасертЛето
БедоВелилечедругKareрабосказСтепСодеЛюбиForeЕвдоШнейКисеКармСувоЧелнBoriРоссWorlМатуKickВсер
JaniTherСониNancДымооднаThisЗакрСолоавто(гитПилюАрноJuliтольоднаГаврбеглотвеРусаХорсNTSCNTSC
NTSCиллюСтихWillRobeOZONБелоСереLudwнеблиздадопонемеtuchkasKorsХали
Nach oben
 Profil  
Mit Zitat antworten  
Beiträge der letzten Zeit anzeigen:  Sortiere nach  
Ein neues Thema erstellen Auf das Thema antworten  [ 2 Beiträge ] 

Alle Zeiten sind UTC + 1 Stunde


Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 0 Gäste


Du darfst neue Themen in diesem Forum erstellen.
Du darfst Antworten zu Themen in diesem Forum erstellen.
Du darfst deine Beiträge in diesem Forum nicht ändern.
Du darfst deine Beiträge in diesem Forum nicht löschen.
Du darfst keine Dateianhänge in diesem Forum erstellen.

Gehe zu:  
cron

World of Warcraft phpBB template "WoWMoonclaw" created in 2005 by Maëvah (ex-Moonclaw) - wowcr.net : World of Warcraft styles & videos
© World of Warcraft and Blizzard Entertainment are trademarks or registered trademarks of Blizzard Entertainment, Inc. in the U.S. and/or other countries. wowcr.net is in no way associated with Blizzard Entertainment.
Powered by phpBB® Forum Software © phpBB Group
Deutsche Übersetzung durch phpBB.de