| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding The Missing Data | Excel Discussion (Misc queries) | |||
| Finding data | Excel Discussion (Misc queries) | |||
| Finding max row containing data... | Excel Discussion (Misc queries) | |||
| Axis label that corresponds to cell | Excel Discussion (Misc queries) | |||
| finding data | Excel Worksheet Functions | |||
Threaded Mode
