Hello,
I'm sure I'm being incredibly dense here but I just can't seem to make this really simple function work.
I have 3 columns that I want to run a formula on - I'm trying to write a formula to look up a value in one column, check another column to see if a specific text appears in it, and if so, return the value from a third column that contains an ID relating to those. So the formula will go in a column for each of those Names to produce their code individually as part of a wider exercise to prep a report that works off several extracts.
ID Name Code Microsoft Apple Ikea
10001 Microsoft M1234
2098 Microsoft M99
30918 Apple A102
09989 Ikea I908
So I'd like to reference the ID column (which will always be unique), check to see if Microsoft appears against that ID, then return the relevant code for that.
=IFERROR(INDEX(G:G,MATCH(H1,'H:H,0)),"")
So G:G is the Name Range
H1 will be a field with the Name - Microsoft for example (there'll be a few columns with that fixed name in it so the reference there will change anyway, H2, H3, etc. to return the code for that in each column
H:H is the Code
That formula doesn't appear to work as I thought it should.
Any help much appreciated, thank you!
I'm sure I'm being incredibly dense here but I just can't seem to make this really simple function work.
I have 3 columns that I want to run a formula on - I'm trying to write a formula to look up a value in one column, check another column to see if a specific text appears in it, and if so, return the value from a third column that contains an ID relating to those. So the formula will go in a column for each of those Names to produce their code individually as part of a wider exercise to prep a report that works off several extracts.
ID Name Code Microsoft Apple Ikea
10001 Microsoft M1234
2098 Microsoft M99
30918 Apple A102
09989 Ikea I908
So I'd like to reference the ID column (which will always be unique), check to see if Microsoft appears against that ID, then return the relevant code for that.
=IFERROR(INDEX(G:G,MATCH(H1,'H:H,0)),"")
So G:G is the Name Range
H1 will be a field with the Name - Microsoft for example (there'll be a few columns with that fixed name in it so the reference there will change anyway, H2, H3, etc. to return the code for that in each column
H:H is the Code
That formula doesn't appear to work as I thought it should.
Any help much appreciated, thank you!