How do you use lookup and reference in excel?
- 1 Answers
- 824 Views
- I also Faced
- E-Mail Answers
Answer / Rizwan Ali
To use lookup and reference in Excel, you can use the VLOOKUP function. The syntax is `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`. Replace lookup_value with the value you want to search for, table_array with the range containing the values, col_index_num with the column number containing the desired result (1-based), and range_lookup with TRUE for approximate matches or FALSE for exact matches.
| Is This Answer Correct ? | 0 Yes | 0 No |
Where is the data validation source in excel?
Where is merge in excel?
How many types of work in ms excel?
How do you delimiter in excel?
How do I match items in excel?
Explain the essential data formats seen in excel?
What is the find function in excel?
How do you limit rows and columns in an excel worksheet?
How do I apply a formula in conditional formatting?
What are the difference between substitute and replace function in ms-excel?
What is meaning of goal seek?
Is r faster than excel?
MS Excel Microsoft 
