Forum Discussion
mbancroft
Jan 04, 2020Copper Contributor
Vlookup value not working properly in other formulas
I am using =vlookup() to obtain values from data that was imported from another workbook (AISC Shapes Database if that helps). I used "Get Data > From File > From Workbook" to get the data into my wo...
Detlef_Lewin
Jan 04, 2020Silver Contributor
- mbancroftJan 06, 2020Copper Contributor
Detlef_Lewin it appears that the value is being treated as text, even though the source data, the imported data, and the vlookup cell are all formatted as numbers. I have copied in the data instead of importing it and that did the trick for now. Thanks for your help!