33.3 C
Ho Chi Minh City
Saturday, July 26, 2025
AIPHOGPT.COM
Trang chủ Blog Trang 25

Hướng dẫn sử dụng hàm LOOKUP trong Excel

Lê Quốc Thái
-
0
Hướng dẫn sử dụng hàm LOOKUP trong Excel

Hàm LOOKUP trong Excel là 1 trong các hàm tham chiếu, hàm tìm kiếm thường được sử dụng. Hàm LOOKUP là hàm nâng cao hơn so với hàm HLOOKUP và VLOOKUP. Hàm LOOKUP có thể dùng khi bạn cần xem 1 hàng hoặc 1 cột và tìm 1 giá trị từ cùng 1 vị trí trong hàng hay cột thứ hai.

Lời khuyên: Để tra cứu các giá trị, nên sử dụng hàm VLOOKUP / HLOOKUP và hàm XLOOKUP mới, vì hàm LOOKUP có nhiều hạn chế hơn trong tính toán. Sử dụng hàm VLOOKUP / HLOOKUP hoặc hàm XLOOKUP, tùy thuộc vào phiên bản Excel bạn đang sử dụng.

  • Hàm VLOOKUP: Nó thực hiện tra cứu theo chiều dọc. Tìm những thứ trong một bảng hoặc một phạm vi theo hàng. Nó có sẵn trong Excel 2007 đến 2021 và Excel cho Microsoft 365.
  • Hàm HLOOKUP: Nó thực hiện tra cứu theo chiều ngang. Tìm những thứ ở hàng trên cùng của bảng hoặc một mảng giá trị theo cột. Nó có sẵn trong Excel 2007 đến 2021 và Excel cho Microsoft 365.
  • Hàm XLOOKUP: Hàm XLOOKUP là hàm tra cứu mới giải quyết được rất nhiều vấn đề mà VLOOKUP và HLOOKUP gặp phải. Nó tìm mọi thứ trong bảng hoặc một phạm vi theo bất kỳ hướng nào (lên, xuống, trái, phải), dễ sử dụng hơn và hoạt động nhanh hơn các chức năng tra cứu khác. Nó chỉ có sẵn trong Excel cho Microsoft 365.

cú pháp

=LOOKUP (lookup_value, lookup_vector, [result_vector])

Lập luận

Lookup_value (bắt buộc): Giá trị bạn sẽ tìm kiếm. Nó có thể là một số, một văn bản hoặc một tham chiếu đến một ô chứa giá trị tìm kiếm.

tra cứu_vector (bắt buộc): Một hàng hoặc dải cột đơn được tìm kiếm. Giá trị trong đối số này có thể là số, văn bản hoặc giá trị lôgic.
Chú thích: Các giá trị trong phạm vi này phải được sắp xếp theo thứ tự tăng dần, nếu không, LOOKUP có thể không trả về giá trị chính xác ..

result_vector (tùy chọn): Hàm LOOKUP tìm kiếm giá trị trong vectơ look_up và trả về kết quả từ cùng một vị trí cột hoặc hàng trong result_vector. Đây là dữ liệu một hàng hoặc một cột có cùng kích thước với lookup_vector.

Giá trị trả lại

Hàm LOOKUP sẽ trả về một giá trị trong phạm vi một cột.

Ghi chú chức năng:

1. Nếu số tra cứu nhỏ hơn tất cả các giá trị trong phạm vi tra cứu, nó sẽ trả về giá trị lỗi # N / A.
2. LOOKUP hoạt động dựa trên đối sánh gần đúng, nếu không tìm được chính xác giá trị tra cứu, nó sẽ khớp với giá trị nhỏ nhất tiếp theo.
3. Nếu có nhiều giá trị tra cứu phù hợp, nó sẽ khớp với giá trị cuối cùng.
4. Hàm LOOKUP không phân biệt chữ hoa chữ thường.

Các ví dụ

Ví dụ 1: Sử dụng hàm LOOKUP để tìm một giá trị với một tiêu chí

Như ảnh chụp màn hình bên dưới, bạn cần tìm Peach trong phạm vi bảng và trả về kết quả tương ứng trong cột Mon, bạn có thể đạt được nó như sau.

Chọn một ô trống, sao chép công thức bên dưới vào đó và nhấn đăng ký hạng mục thi Chìa khóa.
=LOOKUP(H4,B3:E8,D3:D8)

Chú ý:

  • H4 là ô tham chiếu chứa giá trị tìm kiếm “Peach” B3: E8 là phạm vi tra cứu chứa giá trị tìm kiếm và giá trị kết quả; D3: D8 là phạm vi giá trị kết quả.
  • Bạn có thể thay thế H4 bằng “Peach” hoặc B5 trực tiếp nếu bạn cần.
Ví dụ 2: Hàm LOOKUP tìm kiếm một giá trị với nhiều tiêu chí

Như ảnh chụp màn hình dưới đây, có những tên trùng lặp trong các phòng ban khác nhau. Để tìm vị trí của một người cụ thể (Fred Schuler nói), bạn cần đồng thời khớp với tiêu chí Tên và Bộ phận. Hãy làm như sau.

1. Chọn ô trống để đặt kết quả, sao chép công thức bên dưới vào đó và nhấn đăng ký hạng mục thi Chìa khóa.
=LOOKUP(1,0/((B2:B8=F4)*(C2:C8=G4)),D2:D8)

Cách xử dụng hàm Lookup
Cách xử dụng hàm Lookup

Chú ý:

  • Trong công thức, B2: B8 và C2: C8 là các dải cột chứa giá trị tra cứu thứ nhất và thứ hai; F4 và G4 là các tham chiếu đến các ô chứa hai tiêu chí; D2: D8 là phạm vi giá trị kết quả. Vui lòng thay đổi chúng dựa trên phạm vi bảng của bạn.
  • Công thức này cũng có thể hữu ích.
    =LOOKUP(1,0/((B2:B8&C2:C8=F4&G4)),D2:D8)

CCleaner v6.6.0 (Pro Unlocked)

Lê Quốc Thái
-
0
CCleaner v6.6.0 (Pro Unlocked)

The makers of the world’s most popular PC and Mac cleaning software bring you CCleaner for Android. Remove junk, reclaim space, clean RAM, monitor your system and browse safely. Become the master of your own device with the ultimate cleaning app for your Android!

“Cleanliness is next to godliness”. Maybe no one is unfamiliar with that sentence. Cleanliness and tidiness always make everything bright and light out. Cleanliness even makes people feel much better. This is true for all situations and everything, even for mobile. Those who have not used CCleaner MOD APK to clean up your phone, please download and use it immediately. Many useful features are waiting for you.

What does CCleaner help?

CCleaner is an application that helps you remove junk and clean cache for your phone. You may not imagine how much this mess makes your device sluggish. If you don’t believe me, download CCleaner to clean up your phone. After that, restart your phone and surf the web or do any other operation to see how faster it is.

This cleaning job seems simple. However, anyone who has ever cleaned the messy house may know. It’s extremely difficult. To get everything in place, you must go through the process of sorting, considering each item carefully, deciding which ones to keep and which ones to throw away, then cleaning the remaining ones, and finally putting the items in the storage in the desired order after filtering out the unnecessary. CCleaner cleaning process operates the same steps. CCleaner’s smart cleaning is highly appreciated by users. Let’s see how CCleaner does it!

User-friendly interface, easy to use

When you start using CCleaner, you will be presented with a straightforward interface with features divided into tabs that you can easily see. So you tap on the tabs you want to use, and they affect every aspect of your device. You can adjust the performance of your device, media, apps, and more. These are factors that will sometimes cause specific problems in your device. So you can customize the removal of these elements in your way.

Customize features as your wish

Once you have a clear idea of what CCleaner can do, there are two methods you can choose from. The first method is to look at the information that the application sends you and start removing unnecessary things from your device. Also, if you don’t want to take too much time, you can use configurable features such as scanning for a certain period, removing as much space as you like and many more.

Receive information about application capacity

The feature that any user will love is that they will get information about their device’s capacity from CCleaner. So they will have an accessible and overview of their device from which to make changes and remove things they feel are not needed. At the same time, the application uses many different graphs for you to observe easily. It changes depending on the factors that interest you, such as device configuration and its capacity.

Get rid of some unnecessary things

Once you have seen CCleaner’s configuration and capacity information, you can select each element to be removed. The first element is related to the application, where you will find information about it and the applications that you do not use often. From there, you’ll be able to decide to uninstall them to free up space on your device. Also, if there is still some data backlog in the cache or a small folder, you can quickly resolve them.

CCleaner can scan and analyze hard drive status

With built-in AI recognition technology, the CCleaner will first help you scan the entire phone and report the current situation in terms of capacity. It will let you know which part is taking up the most space, which part has the most frequency of use… This information is not for fun but will be the basis for you to confidently choose files, folders, and problematic albums, then put them in the filter list to save space on your phone.

After reporting the status, it will automatically find duplicate and unused files and start to remove junk automatically for the owner.

Do you know why every phone, through the process of use, becomes sluggish even though its capacity is quite large? The main reason is that you copied duplicate files, images, videos, or downloaded files many times without knowing, and also, many files are always there but never (and will never be) used. The capacity is, therefore, wasted too much, leading to the slow-down of the device. The key feature of CCleaner is to solve these problems. CCleaner has great ability of self-scanning, filtering, and searching for files of the above types (duplicate, junk files, unused files). 

And if you allow Ccleaner, it will automatically delete these files within a note. However, this automatic junk removal feature, in my opinion, should be used after you read through the detailed capacity analysis from CCleaner. Take a close look at the rarely used file parts and then decide what to let CCleaner do automatically and what you can do yourself. Make sure not to mistakenly delete important files you may forget their presence on the phone for a long time.

Mod Info

  • Pro Features Unlocked
  • Promo Apps Removed
  • AOSP Compatible / No Google
  • CPUs: arm64-v8a, armeabi-v7a
  • Full Multi Languages
  • All debug Info Removed
  • Original Signature Changed

Download CCleaner Pro 6.6 Mod

Oxford Dictionary of English Premium 14.0.834 Apk + Mod for Android

Lê Quốc Thái
-
0
Oxford Dictionary of English Premium 14.0.834 Apk + Mod for Android

The leading and most trusted single-volume English dictionary is now available for FREE!

WHAT MAKES OXFORD DICTIONARY OF ENGLISH BETTER THAN OTHER DICTIONARIES?

• The most comprehensive coverage of English everywhere it’s spoken
• The very latest vocabulary, with over 350,000 words, phrases and meanings
• Thousands of words and sentences derived from the latest research of the Oxford English Corpus
• 75,000 audio pronunciations of both common and rare words, including words with controversial or variant pronunciations (Premium only)

The Oxford Dictionary of English is a mobile dictionary with content from Oxford University Press, with advanced search and language tools that have become the staple of quality language apps from MobiSystems.

Ideal for professionals, students, and academics, as well as anyone who needs a comprehensive and authoritative dictionary of current English at work or at home.

SEARCH TOOLS – effortlessly find words thanks to a clear, functional, and easy-to-use interface.

Intelligent search integrates several tools to match or suggest what you are looking for:
• Search autocomplete helps find words quickly by displaying predictions as you type
• Keyword lookup allows you to search within compound words and phrases
• An automatic ‘Fuzzy filter’ to correct word spelling, as well as ‘Wild card’ (‘*’ or ‘?’) to replace a letter or entire parts of a word
• Camera search looks up words in the camera viewfinder and displays results
• Share word definitions via installed apps on your device

LEARNING TOOLS – engaging features that help you further enhance your vocabulary.

• ‘Favorites’ feature to create custom folders with lists of words from the extensive library
• ‘Recent’ list to easily review looked-up words
• ‘Word of the day’ section to expand your vocabulary daily
• Home screen widget provides random words at a glance
• *NEW* Split screen support for Android 7 allowing you to use dictionary together with other apps

Get even more with PREMIUM:

• Audio pronunciation – listen to how words are pronounced
• Offline mode – look up words without an internet connection
• Priority support – get expedited support for any app-related issues
• No ads – no more in-app advertisements

* Includes small apps extension for Sony products *

WHAT’S NEW

What’s new:

• The latest 2022 Oxford Languages database
• Bug fixes and performance improvements

Mod

● Premium features Unlocked
● 64-bit CPU Support
● Home view cleaned
● Extra setting to start directly with the dictionary

Download Oxford Dictionary of English Premium 14.0.834 Apk + Mod for Android

Spotify Music 8.7.70.553 (MOD, Premium)

Lê Quốc Thái
-
0
Spotify Music 8.7.70.553 (MOD, Premium)

Spotify is a free music application for Android devices. Here, you can enjoy over 50 million songs of the highest quality

Music is living many times in human life from the Ancient to Modern Life. In the Ancient time people use songs to communicate with the Gods, and after that, the higher dominant classes give back the message to humans in the same way. This is the reason why music made by instrument and vocalist is always important in society. In modern life, music is not essential like the old one, but it is widened than the others. As we all know, songs are releasing day by day by many artists in variation kind of music. It’s suits too many people and the artist their fans.

Spotify Music (MOD, Premium)

Music is an indispensable thing in modern life

There are some people listening to music all day long, and they can leave that are from in any single time. And that reason, the manufacturers in that music industry have many Works to do. First of all, the producer in technology use advantages to releasing many devices to listen to music every year, even every month. And so that the singer and their company try the best to give out as many songs as possible while the compulsory condition that they have to keep the qualities of songs and the beat.

Online music boomed

In the aspect of the listener, the qualities of the song are quite important, but you know the more important for a regular listener is an application to keep the songs in one place. Because when they want to listen to the song they loved, they don’t want to search them on the internet and listened again and again. In the history of the music application, there are so many production best satisfy the requirement of people. But time fly and they are going older and older, and people keep changing every time. They want something more comfortable to use, and more convenient to control.

Spotify Music (MOD, Premium)

And Spotify is the best music app

So that in Modern Life, people love Spotify the most and use it every time they are listening to music. This application what state because they have to use that money to keep that application working in the best status. In our website, we have some advantages that are available unlock for free using. The functions being lockdown by the manufacturer to require the user to pay money for it is all free in our website. Moddroid.com want to show you the best version that is available at this time.

Spotify Music (MOD, Premium)

More than 100 million people are using it

First of all, this is a music application that keeps your music and even your songs in the memory space. Besides, the main function of this is arranged your songs in a clarity order. The highest classify is about the album, and lower is about songs but always alphabet order first. You can adjust it every time you want in dates, artist names, kind music, and many ways. Before Spotify was used in a computer browser, but today the manufacturer of it just released the mobile version does a more convenient for everybody. On Google Play information you can figure out Spotify has their own 100 million downloads for all server. Besides, all the other websites that allowed to download everything you can find out a more significant number maybe reach 1 billion. The number of stats shows everyone the widespread level of that application.

Spotify Music (MOD, Premium)

Discover nearly 50 million songs

On the other hand, Spotify gives you the rights to a set that postcard you can listen to all the artists and albums and even online songs. The user can easily listen to the radio on-air, and when you want to discover the music world, you can do it.

By using albums that are ready on the main page, you can quickly select the things that suit your musical tastes. First, this is a smart tool, so it will read all the searches you have done on its browser and offer valuable suggestions. Besides, the songs are old or hard to find on other search engines YouTube and Google are available. Moreover, songs of the same style are arranged in a category so that listeners can easily find and enjoy it.

Spotify Music (MOD, Premium)

And millions of playlists

Shuffle mode is an interesting tool built into Spotify when you can Click it and let it freely play the song on the music player. Sometimes it will be songs that don’t suit your taste for music, but sometimes it also finds extremely satisfying songs that you can’t find on any other tool. Besides, there are music lists that match the user’s current emotions. Overall, all you need to have is the largest, most complete and most handy music collection tool available in Spotify.

Spotify Music (MOD, Premium)

Create your own radio station

Of course, it is the issuer’s business tool so they will set out a premium version to unlock all that is more convenient than they have provided. Of course, if you don’t want to use your money to buy music tools, you can still enjoy the best song quality. But when unlocked, you have the same advantages as syncing all your music and playlists on any device from your phone to your tablet and PC. The most popular is the music download mode with the highest quality of the song. Of course, everything is free because you have to pay monthly to maintain this account.

Spotify Music (MOD, Premium)

The manufacturer of Spotify has partnered with many different music producers to buy their copyrighted products and upload to their servers so that their users can be right down if they have registered account and use the money to maintain. This version, of course, has no ads – one of the most popular ways to make money with an online application. It also does not provide any binding terms, which means you will be free to terminate the funds if you do not want to use it.

Download:

Spotify Music 8.7.70.553 ARM64 (MOD, Premium) Mod1

Spotify Music 8.7.70.553 ARM (MOD, Premium) Mod1

Spotify Music 8.5.94.839 (MOD, Premium) Mod1

Spotify Music 8.5.94.839 (MOD, Premium) Mod2

Spotify Music 8.6.0.830 (MOD, Premium)

Các bản Android Mod dân Pro cần phải có:

MX Player Pro 1.51.1 (FULL) Apk + Mod for Android

Lê Quốc Thái
-
0
MX Player Pro 1.51.1 (FULL) Apk + Mod for Android

MX Player Pro – The best way to enjoy your movies.
a) HARDWARE ACCELERATION – Hardware acceleration can be applied to more videos with the help of new HW+ decoder.

b) MULTI-CORE DECODING – MX Player is the first Android video player which supports multi-core decoding. Test result proved that dual-core device’s performance is up to 70% better than single-core devices.

c) PINCH TO ZOOM, ZOOM AND PAN – Easily zoom in and out by pinching and swiping across the screen. Zoom and Pan is also available by option.

d) SUBTITLE GESTURES – Scroll forward/backward to move to next/previous text, Up/down to move text up and down, Zoom in/out to change text size.

e) KIDS LOCK – Keep your kids entertained without having to worry that they can make calls or touch other apps. (plugin required)

Subtitle formats:

  • DVD, DVB, SSA/ASS Subtitle tracks.
  • SubStation Alpha(.ssa/.ass) with full styling.
  • SAMI(.smi) with ruby tag support.
  • SubRip(.srt)
  • MicroDVD(.sub)
  • VobSub(.sub/.idx)
  • SubViewer2.0(.sub)
  • MPL2(.mpl)
  • TMPlayer(.txt)
  • Teletext
  • PJS(.pjs)
  • WebVTT(.vtt)

WHAT’S NEW

– We’ve listened to you and added an option to change the sorting order.
– You can now customize the options available in the player interface.
– The player is now more responsive to “touch to play/pause” action.
– Online subtitle search now uses the latest opensubtitles.org APIs.
– We have made a ton of under the hood performance optimizations to make it even faster.

Lite:

– Optimized graphics / Zipalign
– Clean statistics and Google analytics
– Multi Languages

Mod:

– Removed all languages except Russian and English
– Support for ARM and X86 processors
– Disable Analytics
– Remove unnecessary codes to make the application faster

Mod Color:

Replacing all active icons with colored ones
Preferably used in the dark theme with all active buttons (settings / player / navigation / buttons )
Replacing icons (pictures) in a smart lock when you touch the screen (touch effects)
Renamed to MX Video
Replacement icons
Application optimization

Download MX Player Pro 1.51.1 (FULL) Apk + Mod for Android

MX Player Pro 1.51.1 (FULL) Apk

MX Player Pro 1.46.1 (FULL) Apk

MX Player Pro 1.41.9 (FULL) Apk

MX Player Pro 1.39.13 (FULL) Apk

SoundHound Full Mod – Tìm bài hát chỉ cần bật ứng dụng lên

Lê Quốc Thái
-
0
SoundHound Full Mod – Tìm bài hát chỉ cần bật ứng dụng lên

Mô tả SoundHound

Ứng dụng âm nhạc phổ biến với hơn 300 triệu lượt tải về trên toàn cầu!

SoundHound là ứng dụng âm nhạc đỉnh cao của bạn. Chạm vào nút màu cam để ngay lập tức xác định các bài bát và xem lời bài hát, chia sẻ, phát trực tiếp, mua hoặc đơn giản là khám phá thêm về các nghệ sĩ mà bạn biết và yêu thích hoặc vừa mới phát hiện.

Đặc biệt: Bạn cũng có thể tìm kiếm bằng cách hát hoặc ngậm miệng ngân nga với SoundHound, điều này khiến SoundHound trở thành ứng dụng duy nhất trên thế giới có thể cho bạn các kết quả thông qua công nghệ tìm kiếm bằng cách hát/ngân nga trong miệng độc đáo.

Tìm kiếm
• Chạm vào nút màu cam để xác định ngay các bài bát và xem lời bài hát trực tiếp, phát lại video, chia sẻ, phát trực tiếp hoặc mua
• Hát hoặc Ngâm Nga trong SoundHound để đáp ứng những khi bạn không thể đưa bài hát đó ra khỏi đầu mình
• Your History (Lịch Sử của Bạn), hiển thị các tìm kiếm trước đây của bạn (đăng ký để đảm bảo rằng các khám phá trước đây của bạn không bao giờ bị mất!)

Khám phá
• Xem lời bài hát, di chuyển theo nhạc
• Xem các bài hát, video, nghệ sĩ & album đặc sắc hàng tuần
• Music Map (Bản Đồ Âm Nhạc) bao gồm những phát hiện mới về âm nhạc ở gần bạn & trên thế giới
• Tìm hiểu thêm về ‘Artists Born Today’ (Nghệ Sĩ Sinh Hôm Nay), hàng ngày hiển thị các nghệ sĩ vào ngày sinh nhật của họ
• Truy cập ảnh & tiểu sử nghệ sĩ, ngày phát hành album & thông tin ban nhạc
• Xem các bài hát nổi nhất trong trải nghiệm âm nhạc mới qua các biểu đồ Toàn Cầu, Mới Nổi và Nổi Tiếng

Phát
• Trình duyệt các video hàng đầu mà người khác đang xem
• Nghe các bài hát hoặc danh sách phát trong mục yêu thích của bạn được kết nối với các dịch vụ phát trực tiếp, như Apple Music
• Mua các bài hát hoặc album ngay trong Google Play

Đánh Giá và Vinh Danh
• Ứng Dụng về Âm Nhạc Tốt Nhất – Các Giải Thưởng dành cho Ứng Dụng về Âm Nhạc BILLBOARD
• “Thật là thần kỳ” – B.B.C. World Radio
• “Điều này thật…tuyệt vời, phải không?” – David Pogue, NY Times

SoundHound là tất cả những gì bạn thích – miễn phí và không giới hạn. Bạn không muốn nhìn thấy các khung quảng cáo? Hãy nâng cấp ứng dụng của bạn lên SoundHound ∞

Các đối tác bao gồm Spotify, Apple Music, YouTube, Facebook, Twitter, và nhiều hơn thế.

SoundHound – Tìm Bài Hát, Album, Nghệ Sĩ, Lời Bài Hát, Bảng Xếp Hạng, Video

Have you ever had a song stuck in your head that’s driving you crazy, and you can’t even remember what it’s called? A simple application like SoundHound could really come in handy for those times, since it can recognize a song if you just play it – or even hum it – near your smartphone.

Once it has recognized the song (and it’s very rare that it won’t be able to), you can listen to a fragment of the result to make sure that it’s what you were thinking of, and even view videoclips and other related material as long as you’re connected to the Internet.

You can then broadcast your success on Facebook and Twitter, since the application is completely integrated with social networks.

SoundHound is one of the best applications of its category, since it is capable of recognizing almost any song that you play for it without any problems.

DOWNLOAD SoundHound Full Mod 10.1.1

1...242526...203Trang 25 của 203

TĂNG TỐC MẠNG KEY 1.1.1.1

TÔI CHỌN VBA EXCEL

CATEGORY

About Lê Quốc Thái

Yep! I am Le Quoc Thai famous as tnfsmith, one among of netizens beloved internet precious, favorite accumulate sharing all my knowledge and experience Excel, PC tips tricks, gadget news during over decades working in banking data analysis. I am founder AI era: aiphogpt.com , ainextbrain.com

Liên hệ: [email protected]|[email protected]|[email protected]

Follow Lê Quốc Thái

© Cared by LeQuocThai.Com - VBA Excel, APK Mode