Results 1 to 7 of 7

Matching when values are in several possible columns

Threaded View

mgreg Matching when values are in... 06-10-2012, 08:39 AM
dilipandey Re: Matching when values are... 06-10-2012, 09:14 AM
mgreg Re: Matching when values are... 06-11-2012, 09:15 AM
JosephP Re: Matching when values are... 06-11-2012, 10:11 AM
mgreg Re: Matching when values are... 06-12-2012, 12:43 PM
JosephP Re: Matching when values are... 06-12-2012, 03:10 PM
mgreg Re: Matching when values are... 06-13-2012, 11:10 AM
  1. #1
    Registered User
    Join Date
    06-10-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    4

    Matching when values are in several possible columns

    Hi Everyone,

    I'm having trouble coming up with a code for matching one name to several columns, one of which will contain the matching name. To explain better, I have a spreadsheet with birds that have indentifying rings. One ring is metal, the other plastic. The plastic was the easiest to read so that was how birds were recorded. Unfortunately the plastic ring would become difficult to read over time and have to be replaced. Thus, one bird could be recorded under several different plastic ring codes. I now want to match the bird recorded as one of it's possible plastic ring codes to its metal code - and include additional information in adjacent columns. I can do this easily for matching one column (eg:Plastic 1) to the list of observations (shown in spreadsheet, J to L), it's including all possible names (Plastic 2, Plastic 3) where I'm having trouble.

    So in summary, I need to change the formuals in columns J, K, and L to include columns G and H in addition to F. Can anyone suggest a fix? (the name in column J isn't important, just it's placement in the correct row).

    Thanks!
    G
    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