Jump to content
Business Intelligence & Analytics for Digital Transformation

Recommended Posts

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 post
Share on other sites
  • 3 weeks later...

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 post
Share on other sites


×
×
  • Create New...