How can this be done

Giganews Newsgroups
Subject: How can this be done
Posted by:  Bryon
Date: Mon, 15 May 2006

A          B
1 Capital $176.00 <-January value in col b
2 Capital $182.00 <-Feb Value in col b
3 Capital $208.00 <-March value in col b
4 Capital $566.00 <-April Value in col b
5 Capital $561.00 <-May Value in col b

Value
January ???
February ????
March ???
April ???
May ????
I have a table as shown above where column A has the same values as shown
(Capital). In the bottom table I need to return the values found in column B.
Vlookup is not working because the values in Column A are the same. The
actual spreadsheet looks like this, but has 32 other names also with 5 lines
per name as shown above. I for it to be able to find the values in column B
and return them into the appropriate Cell... ie a formula that will find
Capital's Jan value and return that, but then also a way to return Feb, mar,
april and may to the appropriate Cells.

Replies