View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shrek5000 shrek5000 is offline
external usenet poster
 
Posts: 2
Default return 4 lots of data when a corresponding number is entered

I am attempting to retrieve 4 different answers when a postcode(zipcode) is
entered into a cell, data is stored in a 2nd worksheet within 5 columns, when
the number in column 1 is entered into the active cell on the 1st worksheet I
want to have the data from columns 2-5 from 2nd sheet show in 4 different
cells on 1st sheet.