Vlookup range in multiple column

[SAXON10]

Good evening legends,

How to apply the vlookup formula when lookup ranges and value in multiple column.

Data and result same but table range different. I need two different formula based on the following data and table.

Please help me.

Sample workbook attached for your reference.

https://www.dropbox.com/s/lcc22814lqcxcr2/INDEX MATCH.XLSX?dl=0

REQUIRED-1 REQUIRED-2

DATA DATA

[TABLE="width: 789"]
<colgroup><col><col><col span="4"><col><col><col><col span="3"><col></colgroup><tbody>[TR]
[TD]PART[/TD]
[TD]RESULT[/TD]
[TD][/TD]
[TD="colspan: 4"]TABLE-1[/TD]
[TD][/TD]
[TD]PART[/TD]
[TD]RESULT[/TD]
[TD][/TD]
[TD="colspan: 2"]TABLE-II[/TD]
[/TR]
[TR]
[TD]2644[/TD]
[TD] [/TD]
[TD][/TD]
[TD]PART[/TD]
[TD]STATUS[/TD]
[TD]PART[/TD]
[TD]STATUS[/TD]
[TD][/TD]
[TD]2644[/TD]
[TD] [/TD]
[TD][/TD]
[TD]US[/TD]
[TD]UK[/TD]
[/TR]
[TR]
[TD]2693[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2625[/TD]
[TD]US[/TD]
[TD]2683[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2693[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2625[/TD]
[TD]2683[/TD]
[/TR]
[TR]
[TD]2691[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2633[/TD]
[TD]US[/TD]
[TD]2667[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2691[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2633[/TD]
[TD]2667[/TD]
[/TR]
[TR]
[TD]2668[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2654[/TD]
[TD]US[/TD]
[TD]2668[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2668[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2654[/TD]
[TD]2668[/TD]
[/TR]
[TR]
[TD]2667[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2610[/TD]
[TD]US[/TD]
[TD]2685[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2667[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2610[/TD]
[TD]2685[/TD]
[/TR]
[TR]
[TD]2685[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2653[/TD]
[TD]US[/TD]
[TD]2675[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2685[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2653[/TD]
[TD]2675[/TD]
[/TR]
[TR]
[TD]2675[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2658[/TD]
[TD]US[/TD]
[TD]2599[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2675[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2658[/TD]
[TD]2599[/TD]
[/TR]
[TR]
[TD]2460[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2637[/TD]
[TD]US[/TD]
[TD]2691[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2460[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2637[/TD]
[TD]2691[/TD]
[/TR]
[TR]
[TD]2610[/TD]
[TD]US[/TD]
[TD][/TD]
[TD]2652[/TD]
[TD]US[/TD]
[TD]2693[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2610[/TD]
[TD]US[/TD]
[TD][/TD]
[TD]2652[/TD]
[TD]2693[/TD]
[/TR]
[TR]
[TD]2697[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2460[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2697[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD]2460[/TD]
[/TR]
[TR]
[TD]2688[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]2688[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD]2688[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD] [/TD]
[TD]2688[/TD]
[/TR]
[TR]
[TD]2599[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2599[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2626[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2626[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2597[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2597[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2637[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2637[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2652[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2652[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2654[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2654[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2683[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2683[/TD]
[TD]UK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2653[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2653[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2664[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2664[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2633[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2633[/TD]
[TD]US[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2558[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2558[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[SAXON10]

Please help me

 

[Peter_SSs]

You have "bumped" your thread after only about 3 hours and it is weekend when not so many helpers are on the forum. For the future, I suggest that you have a look at the 2nd paragraph in rule #12

 

[SAXON10]

You have "bumped" your thread after only about 3 hours and it is weekend when not so many helpers are on the forum. For the future, I suggest that you have a look at the 2nd paragraph in rule #12

Sorry for the inconvenience. Herewith attached snap shot and workbook for your reference.

https://www.dropbox.com/s/rw649k7mau5kshg/Capture.PNG?dl=0

https://www.dropbox.com/s/z5q5m2znqe255v6/INDEX MATCH.xlsx?dl=0

 

[SAXON10]

I need a formula B4 from the table 1 (DATA RANGE D4:G13) and need a another formula J4 from the table 2 (DATA RANGE L3:M13)

if A4(2644) matched from the table 1 (DATA RANGE D4:G13) return the text in column B4 this is my first requirement and another requirements is if match I4(2644) from the table 2 return the value in column J4.