VLOOKUP FUNCTION

  • Thread starter Thread starter Jeffrey P.
  • Start date Start date
J

Jeffrey P.

When Using VLOOKUP and you need to enter it the number
you are looking up into a formula how does this work. I
tryed using an IF statement, specifing the range of the
number. Then I need to enter three values into a formula
using the vlookup function for each value. How do you
get the number from the vlookup into the equation.

Thank You

Jeffrey P
 
Hi Jeffrey!

Here's the syntax:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Here's an example:

=VLOOKUP(H1,$L$1:$M$12,2,TRUE)


I might enter this formula in J1.
It "looks" at H1 and then searches for the value in H1 in the lookup
table in L1:M12
If it finds that value it returns the data in the second column of the
lookup table
Here's what Help says about the last argument:

"If range_lookup is TRUE, the values in the first column of
table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2,
...., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct
value. If range_lookup is FALSE, table_array does not need to be
sorted. If TRUE or omitted, an approximate match is returned. In other
words, if an exact match is not found, the next largest value that is
less than lookup_value is returned. If FALSE, VLOOKUP will find an
exact match. If one is not found, the error value #N/A is returned."

I suspect that it is this last argument you need to be familiar with.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top