If I do this formula, it can find the value I want:

=VLOOKUP(A2,'Sheet Name'!E2:E,1,FALSE)

However, if I do this formula, it says the same value returned from above does not exist in the search criteria:

=VLOOKUP(A2,'Sheet Name'!A2:E,2,FALSE)

I’m trying to find the value from column A in a range of another sheet so that I get a specific column from that sheet, it would be in column B of that other sheet. But it doesn’t find the A2 in the E column like it did on the previous formula.

This is the error it triggers on that second formula: Did not find value ‘value in A2‘ in VLOOKUP evaluation.

I’m completely lost.