Results 1 to 13 of 13

Vlookup or If/Then to return a substitute cell for a cell that matches itself in a range

Threaded View

Shadefalcon Vlookup or If/Then to return... 11-13-2012, 01:09 PM
tigeravatar Re: Vlookup or If/Then to... 11-13-2012, 01:46 PM
Shadefalcon Re: Vlookup or If/Then to... 11-13-2012, 02:04 PM
Shadefalcon Re: Vlookup or If/Then to... 11-13-2012, 02:05 PM
tigeravatar Re: Vlookup or If/Then to... 11-13-2012, 02:19 PM
Shadefalcon Re: Vlookup or If/Then to... 11-13-2012, 02:29 PM
Shadefalcon Re: Vlookup or If/Then to... 11-13-2012, 02:25 PM
tigeravatar Re: Vlookup or If/Then to... 11-13-2012, 02:32 PM
Shadefalcon Re: Vlookup or If/Then to... 11-13-2012, 02:43 PM
Jacc Re: Vlookup or If/Then to... 11-13-2012, 02:44 PM
tigeravatar Re: Vlookup or If/Then to... 11-13-2012, 02:59 PM
Shadefalcon Re: Vlookup or If/Then to... 11-13-2012, 03:30 PM
Jacc Re: Vlookup or If/Then to... 11-13-2012, 06:02 PM
  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Pittsburgh, PA
    MS-Off Ver
    MS Office 2010
    Posts
    64

    Vlookup or If/Then to return a substitute cell for a cell that matches itself in a range

    I know the title might seem confusing. This is what I'm trying to do.

    I have a list of numbers in column A. Everything to the right of column A in the same row can be represented by the A cell. So A2:A40 are to be represented by A1, etc. I have another sheet where I have the list of all possible numbers. I want to run a formula that will return the value in the A1 cell for all numbers that have matches in A row. So in my other sheet, if A2 comes up, in the column next to it, I want A1 to appear. I'll attach a book to show what I mean. There are two tabs.

    Thanks.
    Attached Files Attached Files
    Last edited by Shadefalcon; 11-13-2012 at 03:33 PM.

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