Page 1 of 1
looking value matter
Posted: Sat Dec 11, 2021 3:31 pm
by sna
Hi Dear,
I need your help how to make formula for looking up a value
I try index with search but no luck
thank in advance
Re: looking value matter
Posted: Sat Dec 11, 2021 3:52 pm
by norkaz
...
B2
=LOOKUP(2,1/SEARCH(IFERROR(LEFT(A2,(SEARCH(" ",A2)-1)),A2),$C$2:$C$3),$D$2:$D$3)
Norkaz
Re: looking value matter
Posted: Sat Dec 11, 2021 5:04 pm
by sna
Thank you ,it works
Re: looking value matter
Posted: Sat Dec 11, 2021 5:52 pm
by norkaz
sna wrote: Sat Dec 11, 2021 5:04 pm
Thank you ,it works
On the other hand, if the main criteria is followed by column C,
B2
=LOOKUP(2,1/SEARCH(LEFT($C$2:$C$3,SEARCH(" ",$C$2:$C$3)-1),A2),$D$2:$D$3)
Norkaz