Hai
I have an sales data with pincode but no Taluk details and District Details. i have to find match from c coloumn to e coloumn data with Taluk and district details.
please help me out on this,
Hai
I have an sales data with pincode but no Taluk details and District Details. i have to find match from c coloumn to e coloumn data with Taluk and district details.
please help me out on this,
What do you expect to see as your result??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Note that column C data is TEXT and E is numeric so you need to have them in the same format for any match to work.
need Result Pincode PINCODE TALUK DISTRICT[/B]
jan 01-Jan 620013 620013 TIRUCHIRAPPALLI TIRUCHIRAPPALLI
san,
c column contains pin code as per my invoice
e column from indian postal directory file
i need area details for my invoice pin code,so i got data from postal directory but it very long process to find area for each pin code, i need some shortcut to workout as i have very big data
Is the attached (yellow columns) what you want?
1. select column C.
Data/text to columns/Finish.
2. In D2, copied across and down.
=IFERROR(VLOOKUP($C2,$G:$I,1+COLUMNS($D2:D2),FALSE),"")
3. Read the yellow banner (top of page) and remember for next time.... as 6,878 rows is slightly in excess of our preferred sample size of 10-20 rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks