adspace


How do I do a lookup table in excel?

Answer Posted / Ashutosh Pandey

"To create a lookup table in Excel, you can follow these steps:
1. Create a table with column headers and the data you want to reference.
2. Select the cell where you want to insert the lookup value.
3. Type `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])` replacing the placeholders with your actual values or references."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much is excel for ipad?

714


Which is latest version of excel?

722


Why can't I see the tabs on my excel spreadsheet?

724


What is wrap text in excel?

721


Image result for how do I compare two columns in excel

668


What is left formula in excel?

685