Cannot figure out formula issue

[crl68]

Hi,

This may not be formula related but I received an AP statement and converted it from PDF to Excel. No issues and have done this before.

Now my formula just will not calculate and I'm confused. I've used it before.

Maybe someone else's eyes will see through my stupidity (if that is what it is) so I'd be most appreciative if someone can let me know if/what I'm missing or if it's something else.

Per attached, I'm simply trying to find their ref on the Main sheet on the Internal sheet and return the value from Internal column A to Main column D, but my formula in Main D2 isn't working but should return the value P00004249 to Main D2 but doesn't.

Thanks for any help!

Cheers

[humdingaling]

not a stupid question at all
it actually happens all the time

notice the cells on internal spreadsheet Column B have a Green Triangle on top left corner
that means the cells reads like a text
ie "12345" is not the same as 12345 so it doesn't match

convert Column B on sheet internal and the formula should work

do this by highlighting the column
press text to column and (in your case) just press finish

if you dont know where to find text to column

https://www.excel-easy.com/examples/...o-columns.html

[Mohish]

Its the formatting problem as mentioned by humdingaling. You can see the desired result by

1. Changing the format to numbers in Internal sheet (To do so, select column B then press Alt A E F) - TEXT TO COLUMN FEATURE.
2. Use the formula in this case =IFERROR(INDEX(Internal!$A$2:$F$274,MATCH(TEXT(Main!B2,0),Internal!$B$2:$B$274,0),1),"") - See the highlighted change.

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )