What are the Lookup Formulas in Ms. Excel
Home
/
What are the Lookup Formulas in Ms. Excel
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
LOOKUP FUNCTIONS:
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column.
For example, let's say you know the part number for an auto part, but you don't know the price. You can use the LOOKUP function to return the price in cell H2 when you enter the auto part number in cell H1.
(IN THE PICTURE)
Tips: Consider one of the newer lookup functions, depending on which version you are using.
Carry on learning :)