Forum Discussion
kelvinwbruce
Jun 29, 2022Copper Contributor
Excel formula not executing
Good afternoon everyone.
I am wondering if anyone might know why my vlookup is not executing, the formula is just sitting in the cell like a text string, even with the = sign in front.
Any thoughts?
Greatly appreciated
3 Replies
Sort By
- kelvinwbruceCopper Contributorformula is : =VLOOKUP(A2,'[6-28-22 Palantir.xlxs]Sheet1'!$A$0,15,0)
Please be sure if Show formula is unchecked
and you didn't apply Text format to the cell(s)
- kelvinwbruceCopper ContributorHello Sergei, Looks like I may have had the column as text.
Sounds like a rookie mistake.
Thank you.
Greatly appreciated