Novice question

[JRM59]

I'll usually spend hours trying to solve Excel questions via Google, but this one has become a time suck.....and is probably very simple for you.

Suppose I have a worksheet of data with the following values:

-------A------------B--------C--------D-----------E--------F
1----TAM 7F------23------45------CD 6F------(-12)------8
2-----CD 6F------22------44-------OP 6F-------(-5)------9
3----TAM 5F------21------45-----GP 1M-------24-------3
4---- GP 6F------23------46-----TAM 7F------(-3)-------5
5---- TAM 6F-----22------45------SA 6F-------12-------8

I'm trying to come up with a formula that would do this:

Specify a value in column A.....say A1 (TAM 7F). Then look down column D until it finds a match, in this case D4.....and end by returning the value in column F4, in this case "5." The spreadsheet obviously contains much more data, and alternatively, in the above example I might be looking for the value in G4 or H4 or AC4, but it would always be in the same row as the match in D4, if that makes sense. I've tried various combinations of IF, AND, MATCH and VLOOKUP, and can't seem to get it right.

 

[JRM59]

And never mind.....it's a simple VLOOKUP using A1. I was trying to make it more complicated. Apologies.

 

[MARK858]

...or an Index/Match (or as you are using 365 there is also XLookup obviously)

Book1
	A	B	C	D	E	F	G	H	I	J
1	TAM 7F	23	45	CD 6F	(-12)	8			5	5
2	CD 6F	22	44	OP 6F	(-5)	9
3	TAM 5F	21	45	GP 1M	24	3
4	GP 6F	23	46	TAM 7F	(-3)	5
5	TAM 6F	22	45	SA 6F	12	8
Sheet1

Cell Formulas
Range	Formula
I1	I1	=INDEX(F:F,MATCH(A1,D:D,0))
J1	J1	=XLOOKUP(A1,D:D,F:F,"",0)