Novice question

JRM59

New Member
Joined
Feb 8, 2025
Messages
2
Office Version
  1. 365
Platform
  1. MacOS
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.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
And never mind.....it's a simple VLOOKUP using A1. I was trying to make it more complicated. Apologies.
 
Upvote 0
...or an Index/Match (or as you are using 365 there is also XLookup obviously)

Book1
ABCDEFGHIJ
1TAM 7F2345CD 6F(-12)855
2CD 6F2244OP 6F(-5)9
3TAM 5F2145GP 1M243
4 GP 6F2346TAM 7F(-3)5
5 TAM 6F2245SA 6F128
Sheet1
Cell Formulas
RangeFormula
I1I1=INDEX(F:F,MATCH(A1,D:D,0))
J1J1=XLOOKUP(A1,D:D,F:F,"",0)
 
Last edited:
Upvote 0

Forum statistics

Threads
1,226,478
Messages
6,191,237
Members
453,649
Latest member
jtc19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top