VLOOKUP returning wrong value

[marykayejn]

My VLOOKUP is returning values from cells above or below the one it should be returning.

In cell Z33 I have =VLOOKUP(C33,Credit,110). It should return a value of 4.4, but instead, returns a value of 12.38, which is the cell beneath.

I have a list of names on two different sheets and all names are on both sheets.
Thanks!

[sandy666]

VLOOKUP function to look up a value in a table.

Syntax

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

For example:
=VLOOKUP(105,A2:C7,2,TRUE)
=VLOOKUP("Fontana",B2:E7,2,FALSE)

lookup_value (required)
The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .
For example, if table-array spans cells B2:D7, then your lookup_value must be in column B. See the graphic below. Lookup_value can be a value or a reference to a cell.

table_array (required)
The range of cells in which the VLOOKUP will search for the lookup_value and the return value.
The first column in the cell range must contain the lookup_value (for example, Last Name in the picture below.) The cell range also needs to include the return value (for example, First Name in the graphic below) you want to find.

col_index_num (required)
The column number (starting with 1 for the left-most column of table-array) that contains the return value.

range_lookup (optional)
A logical value that specifies whether you want VLOOKUP to find an approximate or an exact match:
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one.
FALSE searches for the exact value in the first column.

[gjw1971]

Try =VLOOKUP(C33,Credit,110,FALSE) instead.
Without the FALSE part, the VLOOKUP defaults to an approximate match.

[marykayejn]

Thank you, gjw1971! That worked perfectly!