Results 1 to 2 of 2

Finding item # match on multiple sheets

Threaded View

Crispyglock Finding item # match on... 10-10-2012, 04:10 AM
Jacc Re: Help Project for work due... 10-10-2012, 04:21 AM
  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    SC, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Finding item # match on multiple sheets

    Im creating a vendor comparison for work. What I have is item numbers for products on multiple sheets. I would like to find a function that will search for a item number on multiple sheets and retireve the price in that row.
    So if I have a item number in A2 I want it to search through another sheet to find that same item number and bring back the price, same row but found on column M. When it find the searched item number I want the price to come back to original sheet in a specific column, like the "price" column (M).

    I have a product sheet with prices from multiple vendors. I need all of the vendors prices lined up side by side next to the prospective item # .

    This is a very time sensitive project that was laid on me last second. Please help!
    Last edited by JBeaucaire; 10-10-2012 at 09:40 AM. Reason: Corrected thread title to topic only, as per forum rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1