semi-variable table_array (without vba) in vlookup?

[discoimp]

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

[TABLE="width: 227"]
<tbody>[TR]
[TD]asset ID (A)[/TD]
[TD]Step (B)[/TD]
[TD]ID (C)[/TD]
[/TR]
[TR]
[TD]7148[/TD]
[TD]03 LOOK[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]7148[/TD]
[TD]01 MODEL[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]7148[/TD]
[TD]04 RIG[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]7148[/TD]
[TD]06 SETDRESS[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]7148[/TD]
[TD]05 SHAPES[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]7148[/TD]
[TD]02 TEXTURE[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]7147[/TD]
[TD]03 LOOK[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]7147[/TD]
[TD]01 MODEL[/TD]
[TD="align: right"]1007[/TD]
[/TR]
[TR]
[TD]7147[/TD]
[TD]04 RIG[/TD]
[TD="align: right"]1008[/TD]
[/TR]
[TR]
[TD]7147[/TD]
[TD]06 SETDRESS[/TD]
[TD="align: right"]1009[/TD]
[/TR]
[TR]
[TD]7147[/TD]
[TD]05 SHAPES[/TD]
[TD="align: right"]1010[/TD]
[/TR]
[TR]
[TD]7147[/TD]
[TD]02 TEXTURE[/TD]
[TD="align: right"]1011[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]07 FUR[/TD]
[TD="align: right"]1012[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]03 LOOK[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]01 MODEL[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]04 RIG[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]06 SETDRESS[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]05 SHAPES[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]7114[/TD]
[TD]02 TEXTURE[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]6677[/TD]
[TD]07 FUR[/TD]
[TD="align: right"]1013[/TD]
[/TR]
[TR]
[TD]6677[/TD]
[TD]03 LOOK[/TD]
[TD="align: right"]1014[/TD]
[/TR]
[TR]
[TD]6677[/TD]
[TD]01 MODEL[/TD]
[TD="align: right"]1015[/TD]
[/TR]
</tbody>[/TABLE]

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