Vba to get related cell values

[Azhar0554]

Hi Im new to VBA. I have a question below it would helpful if i got the answer

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Department[/TD]
[TD]Sub_ID[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]8585[/TD]
[TD]00_A01[/TD]
[TD]00_A[/TD]
[/TR]
[TR]
[TD]9585[/TD]
[TD]01_B20[/TD]
[TD]01_B[/TD]
[/TR]
[TR]
[TD]1010[/TD]
[TD]00_C50[/TD]
[TD]00_C[/TD]
[/TR]
[TR]
[TD]2025[/TD]
[TD]05_P20[/TD]
[TD]05_P[/TD]
[/TR]
</tbody>[/TABLE]

I have the above table for data.I want function/sub to search and get/return the value in Sub_Id and ID based on Department value.

The above table is example i have the sheet with 10000 rows

Thanks in advance

 

[FormR]

Hi, sounds like you want VLOOKUP() for example:

Excel 2013/2016
	A	B	C	D	E	F	G
1	Department	Sub_ID	ID		Department	SUB_ID	ID
2	8585	00_A01	00_A		9585	01_B20	01_B
3	9585	01_B20	01_B
4	1010	00_C50	00_C
5	2025	05_P20	05_P
Sheet1

Cell Formulas
Range	Formula
F2	=VLOOKUP($E2,$A$2:$C$5,2,0)
G2	=VLOOKUP($E2,$A$2:$C$5,3,0)

 

[Azhar0554]

Thank you!!