semi-variable table_array (without vba) in vlookup?

[discoimp]

Hi,
I have a huge list looking like this (3 columns):

asset ID (A)	Step (B)	ID (C)
7148	03 LOOK	0
7148	01 MODEL	1
7148	04 RIG	2
7148	06 SETDRESS	3
7148	05 SHAPES	4
7148	02 TEXTURE	5
7147	03 LOOK	6
7147	01 MODEL	1007
7147	04 RIG	1008
7147	06 SETDRESS	1009
7147	05 SHAPES	1010
7147	02 TEXTURE	1011
7114	07 FUR	1012
7114	03 LOOK	7
7114	01 MODEL	8
7114	04 RIG	9
7114	06 SETDRESS	10
7114	05 SHAPES	11
7114	02 TEXTURE	12
6677	07 FUR	1013
6677	03 LOOK	1014
6677	01 MODEL	1015

<tbody>
</tbody>

These are tasks, and I must define dependencies based on what kind of task it is.
In the 4th column I need to link to the tasks predecessor ID.

"04 RIG" is depending on "01 MODEL" so in the top of this table (7148 "04 RIG") the 4th column should read "1". But for Asset ID 7147 "04 RIG" the 4th column should read "1007".

Is it possible in a vlookup (or other function) to define the table_array based on the identical names in a column? If I look up something in row 3 the table_array should be a2:c7 defined by the range of identical Asset ID numbers.

Sorry if I explain myself poorly.

And sorry for not using the "MrExcel HTML Maker" in this post. I lack permissions at my work station...

Best

 

[discoimp]

Sorry if I formulated myself poorly. Can you please let me know what information I should add?
I want the lookup to look something like this: =vlookup(b1,defineRangeByIdenticalEntriesInColumnARelativeToTheLookupValue,3,false)
Best