Hi all,
I have a problem I can't work out. I have a worksheet (colours!) containing general references that look something like this (except much bigger):
A
BLUE
GREEN
RED
PINK
ORANGE
PURPLE
BLACK
WHITE
YELLOW
BROWN
B
bl
gr
re
pi
or
pu
bl
wh
ye
br
C
the sky
a leaf
blood
panther
fruit
rain
gold
knight
sun
dog
My main worksheet contains a column (lets say Main! column D) that contains reference numbers in the format e.g. 10/pu/67. The format is generally the same. There are a very few references that aren't in this format. What I want is a formula that will look at the entry into Main!D, identify the common value in Colours! Column B and fill in corresponding values in Main!E to match Colours!A and Main!:F to match Colours!C.
So in the example of 10/pu/67 above, the result would be
Main!D Main!E Main!F
10/pu/67 PURPLE rain
I've come close with some lookup and search functions, but so far no luck. The talent around here seems to be much better than the one writing this post.
I've think I've followed the rules, but feel free to smack me if I've missed something.
Bookmarks