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.
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.