VLook up not working

This is my formula:

=IFERROR(VLOOKUP($A24,ActiveEmployees!A:D,4,FALSE),"No Match")

In Cell A24: I have the value: C00666314

On the ActiveEmployees tab on cell D1863 I have the value: C00666314

But the value return No Match.

I changed both colums to text. The formula works for one cell but not others any ideas?

Also tried: IFERROR(VLOOKUP("*"&$A24&"*",ActiveEmployees!A:D,4,FALSE),"No Match")

Something else is strange about my excel sheet:

When I try this formula: =IFERROR(VLOOKUP($A26,ActiveEmployees!D:D,1,FALSE),"No Match")
it works on a different cell but I have to click on enter after the formula otherwise the previous value just gets copied.

I have over 1000 records so I can't keep clicking on enter for every field.

Originally Posted by LastJedi

=IFERROR(VLOOKUP($A24,ActiveEmployees!A:D,4,FALSE),"No Match")

In Cell A24: I have the value: C00666314

On the ActiveEmployees tab on cell D1863 I have the value: C00666314

Vlookup is Zoolander Challenged. It can only go 'To The RIGHT'
It finds a match for your lookup value in the LEFT column of the referenced range.
Then returns a value from the designated column 'To The Right' of the column it found the match in.

It seems you want the opposite.
Find the match in column D, but return the corresponding value from column A (To the LEFT)

You'll need INDEX/MATCH for that

=IFERROR(INDEX(ActiveEmployees!A:A,MATCH($A24,ActiveEmployees!D:D,0)),"No Match")