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:
<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:
<tbody>
</tbody>
Can anyone help a person who sucks with excel out?
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?