Results 1 to 3 of 3

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. #1
    New Member
    Join Date
    Nov 2002
    Posts
    4

    Default

    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. #2
    MrExcel MVP DonkeyOte's Avatar
    Join Date
    Sep 2002
    Location
    Suffolk, UK
    Posts
    9,113

    Default

    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)


    Does my a$$ look big in this picture ?

  3. #3
    New Member
    Join Date
    Nov 2002
    Posts
    4

    Default

    THANK YOU!!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com