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
Bookmarks