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

Department	Sub_ID	ID
8585	00_A01	00_A
9585	01_B20	01_B
1010	00_C50	00_C
2025	05_P20	05_P

<tbody>
</tbody>

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!!