View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matheus Matheus is offline
external usenet poster
 
Posts: 16
Default Look up data on the next line

Hi, I've got the following information on a spreasheet:

A B C
1 Asia Measurement 0.64
2 Goal 2.0

The Cell A2 is blank. I can get Asia's C1 data (0.64) with a Vlookup, but I
also want to get Asia's C2 (2.0) data without having to type "Asia" on A2.

Is there a way to do that?