Looking up a Range and selecting Values

[bitswit]

Hi,

I have a list of PINCODE as per encl excel. I need my formula to check on the pincode from another list of 2columns PIN_1 and PIN_2. If the PINCODE falls between PIN_1 and PIN_2, then the values of Country, State and City for that row should be copied into cells B2, C2 and D2.

So for my first row, since pincode=110004 falls within the range 110001-110095, so India, Delhi and New Delhi is copied into my worksheet. Similarly, since 210004 cannot be found, empty cells are returned.

Thanks in advance for your help in this..