HELP!!! Search values of non consecutive rows

[HEAD5ON5]

Hi everyone.

I'm in a desperate situation, I wish to find specific values from one ordered column, of of another i.e:

Searchfrom:	Find value	Return value
1001 a	1001 a	1234
1002b	1002b	222
2001ee	2002d	567
2002d	3002baby	N/A
3001casa	4002bb	real
3002baby
4001aa
4002bb

I wish to use each value from the first column as search reference, to be found in the second column and return de value from the third colum of the same row found.

Thanks! I'm urged!!!!

[#2]

@HEAD5ON5 

Hi

You can use vlookup() function. Please refer the attached file.

Tauqeer