Esseja,

Just to clarify, for your scenario in the Value a column going down the
correct data should read:
2,Missing,150,Missing,120,130,4,Missing,120,130,2, Missing,Missing,130,Missing,150.

Let me know if that's correct
--
Brian


"Esseja" wrote:

I have two sheets like below. In sheet1 I want find value by number to column
"value a" from Value column of Sheet2 if there is "a" in Type column. If
there isn't any "a":s I want return message "missing".
I tried use vlookup function but I don't how I select from two or four lines.

Sheet1
Number Name address Value a value b
101 ab line 1
102 ac line 2
103 cl line 3
104 xka line 4
105 xbx line 5
106 sd line 6
107 lsk line 7
108 jdöd line 8
109 ksldj line 9
110 x.n line 10
111 nsx. line 11
112 xösj line 12

Sheet2
Number Type Name Value
101 a ahsfhflhf 2
101 b ahsfhflhf 100
102 a ahsfhflhf 150
103 a ahsfhflhf 120
104 a ahsfhflhf 130
105 a ahsfhflhf 4
105 b ahsfhflhf 200
106 a ahsfhflhf 120
107 a ahsfhflhf 130
108 a ahsfhflhf 2
108 b ahsfhflhf 52
108 c ahsfhflhf 45
109 a ahsfhflhf 130
110 b ahsfhflhf 140
111 a ahsfhflhf 150


I s that clear enough that somebody could help me?