Help with VLOOKUP

[gleebee]

Hello
I'm a new user and wanting to know the formula that will allow me to choose the rate in Column C if Column A is chosen on another sheet?

Column A	Column B	Column C
Rate A	10	5.85
Rate B	20	5.85
Rate C	30	8.77
Rate D	40	5.85
Rate E	50	8.77

<colgroup><col span="3"></colgroup><tbody>
</tbody>

Many thanks in advance
Regards
Glee

 

[mrshl9898]

Hi,

=VLOOKUP(A2,'Sheet name'!A:C,3,0)

Where A2 is the value you are looking up, and 'Sheet name' is the name of the sheet with this table on it.

 

[gleebee]

Hello
Thanks so much, I should probably have been more detailed in my question, on page 1 there is already a column with a rate chosen from Column A on Page 2, so on Page 1 if Rate A is in the cell, I want to refer back to the other page to see the corresponding rate in Column C?
I hope this makes sense?
Thank you,

 

[mrshl9898]

So if the rate was 5.85 on page 1 would the desired result be Rate A or Rate B?

An example of how the other page looks would be helpful, with a few examples of desired results.

 

[gleebee]

Hello again
Yes basically, but if you choose a Rate from a drop down list which links to Column A on another page, I would like the percentage from Column C to be auto filled if possible? I think this would involve an IF question as well as LOOKUP?

First Page			Second Page
Column A	Column B	Column C		Column B -	Column R
Rate A	10	5.85		Select from dropdown list from Column A - Choose Rate B	Autofills as Rate 5.85 as Rate B chosen
Rate B	20	5.85
Rate C	30	8.77
Rate D	40	5.85
Rate E	50	8.77

<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>

Thank you very much,
Best wishes
Glee

 

[Aladin Akyurek]

First Page = Sheet1, Second Page = Sheet2

In R1 of Sheet2 enter:

=VLOOKUP($B1,Sheet1!A:C,3,0)

which is in fact already suggested to you.

 

[gleebee]

Thank you very much, it works a treat thanks!

 

[Aladin Akyurek]

Thank you very much, it works a treat thanks!

You are welcome. Thanks for the update.