How can we use vlookup in excel?
- 1 Answers
- 753 Views
- I also Faced
- E-Mail Answers
Answer / Prem Singh
To use VLOOKUP in Excel, you should follow this syntax: VLOOKUP(value, table_array, col_index_num, [range_lookup]) where value is the lookup value, table_array is the range that contains the lookup values (in the leftmost column), col_index_num is the column number in the table_array that contains the desired result, and range_lookup determines if an approximate match is acceptable or not. If set to TRUE, VLOOKUP returns the closest match below the lookup value (approximate match). If set to FALSE (the default value), VLOOKUP returns the exact match.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is excel the best spreadsheet?
How do I remove text from one character in excel?
What is colour lookup table?
How to turn on formulas in excel?
Can I use sumif with multiple criteria?
How do I compare two spreadsheets for differences?
What do you mean by lookup?
How many rows and columns are there in microsoft excel 2003 and later versions?
When was ms excel created?
How do you color code in excel?
What is logical function in excel?
What is data summary?
MS Excel Microsoft 
