Thanks:  0
Likes:  0

# Thread: Pulling information from two worksheets

1. 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 ]

2. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•