mcarter973
Board Regular
- Joined
- Mar 24, 2002
- Messages
- 83
i have the following example
Column A Column B
a1: Yankees b1: 10
a2: Mets b2: 20
a3: Dodgers b3: 30
vlookup on the dodgers - 2nd column will return 30 - but what if want the cell directly above (20). is there a formula?
thanks
Column A Column B
a1: Yankees b1: 10
a2: Mets b2: 20
a3: Dodgers b3: 30
vlookup on the dodgers - 2nd column will return 30 - but what if want the cell directly above (20). is there a formula?
thanks