Help on Excel Please.?

Question

Basically I need an IT expert in formulas for EXCEL.

URGENT!

what does VLOOKUP means?


and also what does "TRUE" & "FALSE" means? in Excel terms.

Answer 1

VLOOKUP means Vertical-Lookup and is used to "look up" a value in a vertical table and return one answer if found. It takes the following arguments:

{Lookup_value} Generally the cell reference containing what you are searching for such as "A1" (eg. Employee Code, Part No, Item Code, etc)

{Table_array} The Excel range containing your lookup table generally held in another worksheet such as "Sheet2!A$1:C$18" The '$' needed to "fix" the table position if you drag-paste your vlookup formula down (eg. Rows 1-18 containing your employees with Col A = Emp. Code, Col B = Emp. Name, Col C = Emp. Wage)

{Col_index_num} The Column you want to return on matching your lookup value such as "2" (eg. 2 to return Name or 3 to return Wage in ex. above)

{Range_lookup} True or False where TRUE means closest match while False means EXACT match - You would generally always need this as False for codes, numbers, etc.

This formula is great for entering lets say an item code to retrieve the item description and price - once you reprice or change your lookup table, all your references get updated automatically

Answer 2

There are tons of different types of formulas your can do in excel, repost with the questions or try help in excel.

Answer 3

It looks like this site will answer your question quite well:

http://www.techonthenet.com/excel/formulas/vlookup.php

Answer 4

VLOOKUP is used when a table direction is vertical, or down the worksheet. By far the most often used because most tables are vertical.

Answer 5

You should repost with the formula question

Answer 6

What formula or formulas do you need help with?

Answer 7

Yes, what is the question....?