Results 1 to 5 of 5

Index? Indirect? Match?

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Index? Indirect? Match?

    So I'm def not a power EXCEL user, but I've done some work on it, but not anything involving multiple sheet interactions. What I'm trying to do is when I key an item number into col. E sheet 1, it will look for the matching item number in sheet 2 col. C and then return in sheet 1 col. G the value of sheet 2 col. B of the matching item. Hopefully my attempt at attaching sheet 1 was successful. I frankly have no idea how to execute the formula nor even what to search- I have been searching for the last couple of hours and not turned anything up. Any help is much appreciated.

    Cheers,
    CP
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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