Most valuable professional
  • Hot Topics

Excel Help with Look up reference

Hi, A merry Christmas to you all. Haven't been here for a while and the OS systems have evolved. I am looking for a solution to help me look up a reference such as a zip code and then to find the address. I have a spreadsheet with customer's addresses on it and I need to find a particular addreess, I type in the zip code (post code in UK) and the address should appear. What is happening is that the address does not match the zip code . From that I have another lookup reference to check on a customer's name, which should match up the addrress. The function I am using and have done so before is a simple look up however the addresses are not corresponding to the zipcode EG =LOOKUP(D3,'Booking in'!H5:H300,'Booking in'!G5:G500) I have inserted a simple table with data. Can someone tell me what I have missed? 12/14/2013 12/14/2013 12/14/2013 12/14/2013 12/14/2013

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of December 15, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel