Kashmira Posted November 1, 2020 Share Posted November 1, 2020 Hi Can XLOOKUP / VLOOKUP be useful for the text in the cell. I have a city and postal code in B1 cell. And based on postal code in B1 cell, I want return - package center name . I have table for postal code and center name associated with that postal code. I tried using vlookup and xlookup, but I am not getting the result. Attached is the file. Thanks Kashmira XLOOKUP.xlsx Link to comment Share on other sites More sharing options...
Saurabh Jain Posted November 3, 2020 Share Posted November 3, 2020 You need to extract postal code in a different column and then it can be applied 1 Link to comment Share on other sites More sharing options...
Kashmira Posted November 4, 2020 Author Share Posted November 4, 2020 Thanks. Will try that. Link to comment Share on other sites More sharing options...
Kashmira Posted November 24, 2020 Author Share Posted November 24, 2020 Hello thanks for the idea. i tried this. Extracted postal code with mid( ). When i use vlookup giving reference to this extracted postal code, it gives me error. I cooy postal code and paste as value. Still it gives me an error. Its only when i type the postal code, vlookup gives me data. Is there any way around to overcome this problem. Thanks Kashmirs Link to comment Share on other sites More sharing options...
Recommended Posts