MATCHING a range in a different worksheet

[hsandeep]

I have data in ws with tab named H53 in range B2:F16. In another ws (with tab named Pr) in cell AAE38, I want to get corresponding F of H53 MATCHING $AP38 (of ws with tab named Pr)
How to accomplish. Thanks in advance

 

[PeteWright]

Could you post an example? It's a little difficult to understand what you're looking for.

 

[hsandeep]

Could you post an example? It's a little difficult to understand what you're looking for.

@PeteWright
In G column of Pr ws, I want to fetch F of H53 ws MATCHING non contiguos rows of D (of Pr ws) with contiguos rows of B (of H53 ws)
ws H53

Referencing.xlsx
	B	C	D	E	F
2	41600				999
3	41700				888
4	41800				777
5	41900				111
6	42000				222
7	42100				444
8	42200				555
9	42300				1561
10	42400				10
11	42500				20
12	42600				30
13	42700				40
14	42800				50
15	42900				60
16	43000				70
H53

ws Pr

Referencing.xlsx
	D	E	F	G
2				F of H53
3
4	41900			111
5	42000			222
6	42100			444
7
8	42200			555
9	42300			1561
10
11	42400			10
12	42500			20
Pr

 

[ExceLoki]

you can do a simple vlookup

=VLOOKUP(D4,'H53'!$B$2:$F$16,5,FALSE)

you might need to adjust the 'H53'!$B$2:$F$16 part to your full lookup range

 

[hsandeep]

you can do a simple vlookup

=VLOOKUP(D4,'H53'!$B$2:$F$16,5,FALSE)

you might need to adjust the 'H53'!$B$2:$F$16 part to your full lookup range

@ExceLoki Thanks for your time & efforts. Is it compulsory to adjust?

 

[ExceLoki]

if your lookup data range is bigger than the range in the above formula, and you want the rest of the range looked at for matches.... yes.

 

[hsandeep]

if your lookup data range is bigger than the range in the above formula, and you want the rest of the range looked at for matches.... yes.

My total data/range is as posted in thread #3.

 

[ExceLoki]

then the given formula should work fine.

 

[hsandeep]

then the given formula should work fine.

@ExceLoki Thanks now clear.

 

[ExceLoki]

glad to help