Pulling information from two worksheets

Alexander · Apr 19th, 2002, 01:34 PM

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 · Apr 19th, 2002, 01:37 PM

Quote:

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 · Apr 19th, 2002, 02:10 PM

Thanks, Aladin. Works great!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 01:34 PM	#1
Alexander New Member Join Date: Apr 2002 Posts: 45	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 ]

Apr 19th, 2002, 02:10 PM	#3
Alexander New Member Join Date: Apr 2002 Posts: 45	Thanks, Aladin. Works great!