Hi,

Try this:

=VLOOKUP(A334,A1:F326,3,FALSE)

Thanks,
--
Farhad Hodjat


"bob" wrote:

ive tried using vlookup and lookup to no avail. i cant figure out how to do
it. can anyone suggest the correct function? for the purposes of assisting
me, assume

* my data is 326 rows long and 6 columns wide
* im trying to enter my vlookup formula in B334, and using A334 as the place
where I am entering test data from column A. my vlookup formula looks like
this

=VLOOKUP(A334,A1:F326,3)

* unfortunately, it's not returning the value that appears in the 3rd column
of the 26th row. thoughts?