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?

[TABLE="width: 207"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]Rate A[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5.85[/TD]
[/TR]
[TR]
[TD]Rate B[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5.85[/TD]
[/TR]
[TR]
[TD]Rate C[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]8.77[/TD]
[/TR]
[TR]
[TD]Rate D[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5.85[/TD]
[/TR]
[TR]
[TD]Rate E[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]8.77[/TD]
[/TR]
</tbody>[/TABLE]

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?

[TABLE="width: 875"]
<colgroup><col span="4"><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]First Page[/TD]
[TD][/TD]
[TD][/TD]
[TD]Second Page[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD][/TD]
[TD]Column B -[/TD]
[TD]Column R[/TD]
[/TR]
[TR]
[TD]Rate A[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5.85[/TD]
[TD][/TD]
[TD]Select from dropdown list from Column A -
Choose Rate B[/TD]
[TD]Autofills as Rate 5.85 as Rate B chosen[/TD]
[/TR]
[TR]
[TD]Rate B[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]5.85[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rate C[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]8.77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rate D[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5.85[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rate E[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]8.77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.