View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default finding data in col E that corresponds to data in col A

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?