Search for a value in one column then return it based on a list in another

[Kenshomyte]

Hi All

Can someone help?

I am trying to search for a value in one column then return it based on a list in another, So far I have set up this formula but I can't nest it for multiple values (ie values in Call A), and I can't get it to work for more than one search criteria.

=IF(ISNUMBER(SEARCH("1.1*",A2)),"Group A","")

A B C D

Ref	Result	Group List		Guide
1.1	Group A	Group A		Group A Starts 1…
2.1		Group B		Group B Starts 2.1..
3.1.2.1		Group C		Group C Starts 3.1..
4.1.1.1		Group D		Group D Starts 4.1..
5.5		Group E		Group E Starts 5.5..
5.6.5.5		Group F		Group F Starts 5.6..
1.3		Group G
2.1.1		Group H

<tbody>
</tbody>

Column A = References I am searching through (will need to use a wildcard just to pick out the first 2 digitts of each ref)

Column B = The result I want to display based on the first two digits of the ref (ie anything starting with 1.1* is Group A)

Column C = This is the list from which the result is taken (the groups)

Column D = is just additional info for purposes of this post.

Any help is apprecated, help I'm stuck

Ken

 

[Michnia25]

try this:

{=INDEX($F$5:$F$12,MATCH(LEFT(D5,3),LEFT($D$5:$D$12,3),0))}

 

[Kenshomyte]

WOW!!! Michnia25 you're a genius!!!

Thanks worked a treat