Formula to change cell based on info from another sheet?

vdemattei

@Paul Newcome, I've been applying this formula to various different items/sheets in my different workflows - with much success! Except for 1 instance. In this particular instance, there is only 1 real match (for now), but for each ID number AFTER the 1 match, it is returning the same name. Here is the screen shot:

The first instance of "Judith" is the correct one, but it keeps returning the same name for subsequent ID numbers.

Here's my formula:

Here's the other sheet:

23.118 is the only ID number there at the moment... eventually more will show up.

I'm not sure why, if they don't show up in this reference sheet, ID numbers "23.119", "23.120", etc. would bring back any result at all? This happened when I converted the formula to a column formula. I had originally entered it in Judith's row because I knew that was the only one were I'd have a positive return. I did use "@row", though... so when it was converted to a column formula, the @row should apply to each individual row, right?

If you have time to help, I'd greatly appreciate it!

Paul Newcome

@vdemattei Try moving the zero at the end to inside of the MATCH function instead fo as the third portion of the INDEX function.

You have

{Range}), 0)

You need

{Range}, 0))

vdemattei

I think that did it! Thanks! Sorry... I'm still very new to these "more advanced" formulas and still don't totally understand them. Again, I really appreciate your time and effort in helping me!

Paul Newcome

Happy to help. 👍️