# Lookup function

This is a discussion on Lookup function within the Excel Questions forums, part of the Question Forums category; Here is what I need to do: Bring a price in sheet PL to sheet "A" by matching the product ...

1. Here is what I need to do: Bring a price in sheet PL to sheet "A" by matching the product code in another sheet and return the price in the row that matches that product code. What does that formula look like?

2. On 2002-11-16 08:35, edwright wrote:
Here is what I need to do: Bring a price in sheet PL to sheet "A" by matching the product code in another sheet and return the price in the row that matches that product code. What does that formula look like?

Assuming that Code being looked up is in Column A of both the PL sheet and Sheet A and that the price is in column B of PL Sheet
Formula in B1 of Sheet A would be:

=VLOOKUP(A1,PL!A:B,2,False)

3. THANK YOU!!!

#### Posting Permissions

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