View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] it@clowwater.com is offline
external usenet poster
 
Posts: 9
Default Vlookup to Return Cell Name Not Value?

I'm wondering if I can do the following with this table...on
tab1(snippet of raw data)
colA colB
2 55
3 57
6 51
9 40
10 42

I was trying to get vlookup to to work on tab2...
colA colB
3 * this is where I want to use vlookup
9

What I need to do is sum up all values in tab1.colB from 3 through 9.
So I was thinking if I could get vlookup to return the cell number
then I can do a sum from the return value. I hope I'm making this
clear. Any help is appreciated.

-Bruce