VBA value to left of column

[Jaye7]

I have a value in cell F8 of sheet 1, I want to lookup F8 within sheet2 column B but return the value that is in column A not column B, I tried index and match but I haven't used them before and just get an error.

 

[Jaye7]

sorry the title is wrong, it should be just a vlookup or index or match, I don't need VBA

 

[LegendaryAxe]

Try

=INDEX(Sheet2!A:A,XMATCH(F8,Sheet2!B:B))

 

[MARK858]

Like the below?

Book2
	C	D	E	F
8	77			46
Sheet1

Cell Formulas
Range	Formula
C8	C8	=INDEX(Sheet2!A2:A13,MATCH(F8,Sheet2!B2:B13))

Book2
	A	B
1
2	2	38
3	42	26
4	5	1
5	44	17
6	48	27
7	77	46
8	5	24
9	30	50
10	4	31
11	2	14
12	9	45
13	49	47
Sheet2

 

[Jaye7]

Thanks for your help, much appreciated

 

[MARK858]

You're welcome, happy we could help