Hi,
I'm stumped here. I think this can be done. Well I'm sure it can be done. I just don't know how to do it. What I am looking for is a formula to do a unique word lookup and match. I have a simple sample. Keep in mind the "list of Unique Words" will be several hundred in length. otherwise I think it could be done with an IF statement if it was only a couple long. I believe it might be index however I'm not 100% sure, which is why I am hoping some excel GURU can toss me the answer.
<tbody>
</tbody>
I'm stumped here. I think this can be done. Well I'm sure it can be done. I just don't know how to do it. What I am looking for is a formula to do a unique word lookup and match. I have a simple sample. Keep in mind the "list of Unique Words" will be several hundred in length. otherwise I think it could be done with an IF statement if it was only a couple long. I believe it might be index however I'm not 100% sure, which is why I am hoping some excel GURU can toss me the answer.
Sheet 1 | Sheet2 | ||||||||||
A | B | C | D | E | F | K | A | B | |||
Date | N/A | Description | N/A | N/A | Need Formula to look at column C and determine unique word From Sheet 2 | Vlookup to return Unique Word Value | List of Unique Words | Unique word value | |||
The cat jumped over the moon | ***Formula should return CAT*** | I can do Vlookup no problem here | cat | Furry | |||||||
The dog ran to fetch the frisby | ***Formula should return DOG*** | dog | Furry | ||||||||
The frog is croaking outside | ***Formula should return FROG*** | Fish | slimy | ||||||||
The fish swims in its bowl | ***Formula should return FISH*** | Frog | noisy |
<tbody>
</tbody>