E
Esseja
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?
"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?