Question about which function to use to transpose data?

[kkoliver]

I`m not sure if this is a basic question thats been answered countless times, but I was wondering which excel funtion I would need to use to do the following. I´ve scoured the internet and am still not really sure what function would do what I want. On one sheet, I have a simple table, with month/date in the A column, and a corresponding rate in the B column, like so:

Jan/09	1.4%
Feb/09	1.7%
Mar/09	1.6%
Apr/09	2.1%

<tbody>
</tbody>

Now, is there any way to set up the following function on another sheet? I want to be able to type in any of the values from column A of the original table (month/year) into column A of the new sheet. I then would like excel to return the corresponding value from the original table in, say, the F column of the new shet. It would more or less look like this:

Feb/09	N/A	N/A	N/A	N/A	1.7%	N/A
Feb/09	N/A	N/A	N/A	N/A	1.7%	N/A
Jan/09	N/A	N/A	N/A	N/A	1.4%	N/A
Apr/09	N/A	N/A	N/A	N/A	2.1%	N/A
Mar/09	N/A	N/A	N/A	N/A	1.6%	N/A

<tbody>
</tbody>

Can anyone help a person who sucks with excel out?

 

[timfritsch]

Start here: Using VLOOKUP in Excel


Tim

 

[BrianG86]

Looks like a simple vlookup would do the trick.

= vlookup(A2,Sheet1!A2:B5,2,false)

 

[kkoliver]

Thanks guys. I kept trying to do it with Match and Index and couldn´t get what I wanted. Ya´ll are awesome. Just saved me at least a dozen hours of work. Appreciate it!