[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]d
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]dog
[/TD]
[TD]dog1
[/TD]
[TD]dog 2
[/TD]
[TD]dogs
[/TD]
[TD]Dogs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]cat
[/TD]
[TD]cats
[/TD]
[TD]cat1
[/TD]
[TD]cat 2
[/TD]
[TD]Cat
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]hamster
[/TD]
[TD]hamsters
[/TD]
[TD]hamster1
[/TD]
[TD]hamster 2
[/TD]
[TD]hamster
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hi all - Happy New Year.
I was hoping the Excel guru's on this forum can assist me with my issue.
I currently have the above worksheet. Table would be defined as A1:D3. I'm looking for a formula to put in cell F1 that will take the value of cell E1 (which is "Dogs"), and look for a partial match in table A1:D3 (look for any instance that might have "Dogs", an return the corresponding value of column A. So looking for cell E2- instances of "Dogs", it would cell D1 ("dogs") and return cell A1 - "dog"
thank you in advance for the help!
<tbody>[TR]
[TD][/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]d
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]dog
[/TD]
[TD]dog1
[/TD]
[TD]dog 2
[/TD]
[TD]dogs
[/TD]
[TD]Dogs
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]cat
[/TD]
[TD]cats
[/TD]
[TD]cat1
[/TD]
[TD]cat 2
[/TD]
[TD]Cat
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]hamster
[/TD]
[TD]hamsters
[/TD]
[TD]hamster1
[/TD]
[TD]hamster 2
[/TD]
[TD]hamster
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hi all - Happy New Year.
I was hoping the Excel guru's on this forum can assist me with my issue.
I currently have the above worksheet. Table would be defined as A1:D3. I'm looking for a formula to put in cell F1 that will take the value of cell E1 (which is "Dogs"), and look for a partial match in table A1:D3 (look for any instance that might have "Dogs", an return the corresponding value of column A. So looking for cell E2- instances of "Dogs", it would cell D1 ("dogs") and return cell A1 - "dog"
thank you in advance for the help!