CODEWITHSUNDEEP
excelexcel-formula
Farooq Sk
Farooq Sk

Reputation: 124

IF() function not working on Numbers fetched with VLOOKUP()

I have fetched some values with VLOOKUP from another sheet into column B and column E. Both Column B and E shall match and they are as you can see. But when I run the function IF(B# = E#,TRUE,FALSE), it is only working on text and failing on numbers in column "I"

Can anyone guide me with this please ?

enter image description here

Upvotes: 1

Views: 372

Answers (2)

Farooq Sk
Farooq Sk

Reputation: 124

JvdV was right, I initially pasted values in the 'paste' sheet from where the VLOOKUP is fetching the data to this sheet. I took a look at 'paste' sheet and there were correction tags on numbers with "Numbers stored as text", I had to use =VALUE(VLOOKUP(XYZ)) to fetch numbers and the IF started working well.

Upvotes: 1

JvdV
JvdV

Reputation: 75840

As per my comment, the IF formula will work fine on numbers. You won't be the first to have pasted values that look like numbers but are formatted as text and though might end up with trailing spaces or other unseen characters.

You can edit your formula to account for that but its more recommendable to go to your vlookup data and see if you can rework that data.

Good luck =)

Upvotes: 1

Related Questions