{"id":1195,"date":"2018-07-02T16:59:59","date_gmt":"2018-07-02T16:59:59","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1195"},"modified":"2023-11-03T10:07:47","modified_gmt":"2023-11-03T10:07:47","slug":"lookup","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/lookup\/","title":{"rendered":"LOOKUP function"},"content":{"rendered":"\n
Excel LOOKUP Function allows you to search for a value in a specific range or table and return a corresponding value from another range or table. It’s like finding information in a big book and using a reference to get the answer.<\/p>\n\n\n\n
=LOOKUP(lookup_value, lookup_vector, result_vector)<\/strong><\/p>\n\n\n\n Here’s a breakdown of the function’s arguments:<\/p>\n\n\n\n Let’s break down how to use the LOOKUP function with an example:<\/p>\n\n\n\n Imagine you have a list of student names in one column and their corresponding test scores in another column. You want to find a specific student’s test score.<\/p>\n\n\n\n In this example:<\/p>\n\n\n\n The LOOKUP function will search for “John” in the student names, and when it finds a match, it returns the corresponding test score. If “John” is in A3, it will return the test score from B3.<\/p>\n\n\n\n Here are a few things to keep in mind:<\/p>\n\n\n\n Now, let’s see what happens if we use the LOOKUP function with a value that isn’t in the list:<\/p>\n\n\n\n If “Sarah” isn’t in the student names, the function will return the test score of the student with the name closest to “Sarah” alphabetically. So, it’s crucial to ensure your data is correctly sorted.<\/p>\n\n\n\n The LOOKUP function is a useful tool for finding data in large lists or tables, but it requires careful data organization to work effectively.<\/p>\n","protected":false},"excerpt":{"rendered":" Excel LOOKUP Function allows you to search for a value in a specific range or table and return a corresponding value from another…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
lookup_value<\/strong><\/td> The value you want to find in the lookup_vector.<\/td><\/tr> lookup_vector<\/strong><\/td> The range of cells where Excel will search for the lookup_value.<\/td><\/tr> result_vector<\/strong><\/td> The range of cells from which Excel will return a corresponding value.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=LOOKUP(\"John\", A1:A5, B1:B5)<\/code><\/pre>\n\n\n\n
\n
\n
=LOOKUP(\"Sarah\", A1:A5, B1:B5)<\/code><\/pre>\n\n\n\n