Pulling information from two worksheets

[Alexander]

How do I write this formula? I need to put the information from a table, comprised of two columns (B & C), found on Sheet 2, into one column (A) found on Sheet 1. It could be done as an If statement: If on Sheet 2, column B are varieties of candy and Sheet 2, column C has the price of each, Then the price for the item on Sheet 1, A1 would be ___. How do I write that?
This message was edited by Alexander on 2002-04-19 12:35
This message was edited by Alexander on 2002-04-19 12:36

 

[Aladin Akyurek]

On 2002-04-19 12:34, Alexander wrote:
How do I write this formula? I need to put the information from a table, comprised of two columns (B & C), found on Sheet 2, into one column (A) found on Sheet 1. It could be done as an If statement: If on Sheet 2, column B are varieties of candy and Sheet 2, column C has the price of each, Then the price for the item on Sheet 1, A1 would be ___. How do I write that?

=VLOOKUP(A1,Sheet2!$B$2:$C$100,2,0)

Adjust the range in Sheet2 to suit.

Aladin

 

[Alexander]

Thanks, Aladin. Works great!