Look Up formula

[Taff]

looking for help with something outside my comfort zone

In cell A1 in workbook "result " I need the contents of Cell B20 from workbook "example", worksheet "show" when it matches the contents of cell B2

Normally I would use VLookup

But the cells are offset, ie the target cell/matching cell is in A3, and the answer cell is B20

Any ideas/views appreciated.....

 

[Sam_D_Ben]

What is the value in B3, is it empty.

Thanks Muz

 

[Sam_D_Ben]

You mean like this,

Excel 2013/2016
	A	B	C	D	E	F	G	H
1						WB-Example
2
3	10	Test
4						Sheet-Report
5						10
6
7
8
9
10							Test
11
result

Cell Formulas
Range	Formula
B3	=OFFSET(INDEX(F:G,MATCH(A3,F:F,0),2),5,0)

Thanks Muz

 

[Taff]

Muz,

cheers for this, pointed me in the right direction, much appreciated

Taff

 

[Sam_D_Ben]

Well thank you Taff.