شرح عربى للدالة LOOKUP - ميكروسوفت إكسل - Microsoft Excel

Share this & earn $10
Ahmed Samy Elkady
Published at : 06 Dec 2020
27360 views
271
14

How to use LOOKUP Function in Microsoft Excel.

الدالة LOOKUP: للبحث عن شئ فى عمود و تعطى نتيجة من عمود آخر لا يُشترط أن يكون على اليمين عمود البحث.
و فى صف و تعطى نتيجة من صف آخر لا يُشترط أن يكون على أسفل صف البحث.
و فى عمود و تعطى نتيجة من صف آخر فى أى مكان.
و فى صف و تعطى نتيجة من عمود آخر فى أى مكان آخر.
الدالة VLOOKUP: للبحث عن شئ بطريقة رأسية " عمودية " تبحث فى عمود و تعطى نتيجة من عمود آخر على يمين عمود البحث.
الدالة HLOOKUP: للبحث عن شئ بطريقة أفقية و تعطى نتيجة فى صف آخر أسفل صف البحث.

شرح الدالة VLOOKUP على اليوتيوب : https://youtu.be/eZiLLT5jfUM
شرح الدالة HLOOKUP على اليوتيوب : https://youtu.be/gqXCwN6jkto

يمكنك الوصول الى المزيد من المعلومات في الإكسل عبر البحث عن هذه الموضوعات:
Excel Tutorial
Excel training
Excel help
Microsoft excel help
Excel courses
Online excel training
Microsoft office training
Free excel training
Learn excel online
Microsoft Excel Tutorial
Excel VLOOKUP
Excel HLOOKUP
Excel LOOKUP
شرحعربىللدالة

Algebra Introduction - Basic Overview - Online Crash Course Review Video Tutorial Lessons

Algebra Introduction - Basic Overview - Online Crash Course Review Video Tutorial Lessons

KDtheSinger - "Make Your Mind Up" OFFICIAL VERSION

KDtheSinger - "Make Your Mind Up" OFFICIAL VERSION

What the Heck Is This Minecraft Ad..?

What the Heck Is This Minecraft Ad..?

Most Adorable Ferret Video Ever August 2018 | Funny Pet Videos

Most Adorable Ferret Video Ever August 2018 | Funny Pet Videos

Best Fails I Had With My Friends (2020) | FailArmy

Best Fails I Had With My Friends (2020) | FailArmy

Passenger removed from plane for refusing to comply with flight's face mask requirement

Passenger removed from plane for refusing to comply with flight's face mask requirement

I Don't Have Much - Corey Voss & Sarah Kroger, REVERE (Official Live Video)

I Don't Have Much - Corey Voss & Sarah Kroger, REVERE (Official Live Video)

How batteries work - Adam Jacobson

How batteries work - Adam Jacobson

North South East West | Cardinal Directions | Geography for Kids | Geography Games

North South East West | Cardinal Directions | Geography for Kids | Geography Games

Coming Back To Life | 2 Weeks Out

Coming Back To Life | 2 Weeks Out

La réplication de l'ADN

La réplication de l'ADN

อัลบั้มรวมเพลงประกอบภาพยนตร์ เก๋า เก๋า

อัลบั้มรวมเพลงประกอบภาพยนตร์ เก๋า เก๋า

World's Most Famous Magic Tricks Revealed

World's Most Famous Magic Tricks Revealed

Over 6 million people participated in Venezuela's 'popular consultation'

Over 6 million people participated in Venezuela's 'popular consultation'

When Elvis Presley Joined The Army | 4K 60fps

When Elvis Presley Joined The Army | 4K 60fps

🔴 Relaxing Music 24/7, Meditation Music, Sleep Music, Stress Relief Music, Spa, Yoga, Zen, Relax

🔴 Relaxing Music 24/7, Meditation Music, Sleep Music, Stress Relief Music, Spa, Yoga, Zen, Relax

WAY OF LIFE - 13 (Mizo Comedy Love Story)

WAY OF LIFE - 13 (Mizo Comedy Love Story)

Jethro Tull -  We Used to Know

Jethro Tull - We Used to Know

How often is the dictionary updated?

How often is the dictionary updated?

Clinical Informatics for Varied EHR Systems - Casey Overby

Clinical Informatics for Varied EHR Systems - Casey Overby

Affordable AJIO haul l kurtis, footwear, top l kurtis starting at Rs 282only😮

Affordable AJIO haul l kurtis, footwear, top l kurtis starting at Rs 282only😮

Lincoln Project releases attack ad on Sen. Josh Hawley

Lincoln Project releases attack ad on Sen. Josh Hawley

6 Most Dangerous Provisions of Income Tax | Section 270A | 144 | 147 | 148 | 131 | 276B | Taxpundit

6 Most Dangerous Provisions of Income Tax | Section 270A | 144 | 147 | 148 | 131 | 276B | Taxpundit

D-Faction - Down In The Boondocks (THE VIDEO!!!)

D-Faction - Down In The Boondocks (THE VIDEO!!!)

The Greatest NFL Game That Nobody Watched

The Greatest NFL Game That Nobody Watched

PnB Rock - Nowadays [Official Music Video]

PnB Rock - Nowadays [Official Music Video]

اتصال شرطة الأطفال | إذا إبنك ما بيسمع الكلمة بنصحك بالفيديو وراح يطيعك فوراً | خاص بالأولاد فقط

اتصال شرطة الأطفال | إذا إبنك ما بيسمع الكلمة بنصحك بالفيديو وراح يطيعك فوراً | خاص بالأولاد فقط

MLB Weirdest Pitching Styles

MLB Weirdest Pitching Styles

How the skills of improvisation can free us to be ourselves | Tom Lovegrove | TEDxImperialCollege

How the skills of improvisation can free us to be ourselves | Tom Lovegrove | TEDxImperialCollege

Chad Valley - Impartial

Chad Valley - Impartial

Whatever the MYSTERY Wheel Hits, I'll Do - Football Challenge

Whatever the MYSTERY Wheel Hits, I'll Do - Football Challenge

This is the Reason Why our WORLD is FAnTASTIC

This is the Reason Why our WORLD is FAnTASTIC

ANTHONY JOSHUA'S NANDO'S CHEAT MEAL CHALLENGE | AJ'S SIGNATURE NANDO'S ORDER X 3 | BeardMeatsFood

ANTHONY JOSHUA'S NANDO'S CHEAT MEAL CHALLENGE | AJ'S SIGNATURE NANDO'S ORDER X 3 | BeardMeatsFood

FINDING BIGFOOT GAME! (scary)

FINDING BIGFOOT GAME! (scary)

Should You Shave Your Pubes?

Should You Shave Your Pubes?

Most Backpackers Are Thinking About Insulations WRONG!

Most Backpackers Are Thinking About Insulations WRONG!

ICT Policies

ICT Policies

Solomon Burke - None Of Us Are Free

Solomon Burke - None Of Us Are Free

EDD16 - Special event - Local action to address fragility and protracted displacement

EDD16 - Special event - Local action to address fragility and protracted displacement

Keynote: Anima Anandkumar - Tensorly: A Flexible Python Framework for Machine Learning

Keynote: Anima Anandkumar - Tensorly: A Flexible Python Framework for Machine Learning

When Elon Musk Realized China's Richest Man Is A Dope (Jack Ma)

When Elon Musk Realized China's Richest Man Is A Dope (Jack Ma)

Carolina Drama - Jack White | Live from Here with Chris Thile

Carolina Drama - Jack White | Live from Here with Chris Thile

Elon Musk's Neuralink May Help us Merge With AI & Artificial Superintelligence

Elon Musk's Neuralink May Help us Merge With AI & Artificial Superintelligence

Brisker & Magitman - Bad Asss (Original Mix) HQ

Brisker & Magitman - Bad Asss (Original Mix) HQ

Subject-Verb Agreement

Subject-Verb Agreement

SEEN  - Trịnh Thăng Bình (Lyrics Video)

SEEN - Trịnh Thăng Bình (Lyrics Video)

Live Forex Trading & Top Trade Ideas for 2021! (Come say Hi!)

Live Forex Trading & Top Trade Ideas for 2021! (Come say Hi!)

Bedtime Stories for Grown Ups | Reading from "The Children of Odin" ⚡ Norse Myths ⛰️ Without music

Bedtime Stories for Grown Ups | Reading from "The Children of Odin" ⚡ Norse Myths ⛰️ Without music

MANY, MUCH, A LOT OF, PLENTY OF - QUAL A DIFERENÇA?

MANY, MUCH, A LOT OF, PLENTY OF - QUAL A DIFERENÇA?