|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2008, 10:58 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
August 6th, 2008, 11:16 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return 4 lots of data when a corresponding number is entered
With your postcode entered into A1 on Sheet1, put this formula in B1:
=VLOOKUP($A1,Sheet2!$A:$E,COLUMN(B1),0) Then copy this formula into C1:E1. Hope this helps. Pete On Aug 6, 10:58*am, shrek5000 wrote: 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.
|
|
#3
August 6th, 2008, 01:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return 4 lots of data when a corresponding number is entered
Thanks Pete, it worked just as I had wanted, I just had to change a few cell
refrences but it worked a treat, your help is very appreciated  Scott "Pete_UK" wrote: With your postcode entered into A1 on Sheet1, put this formula in B1: =VLOOKUP($A1,Sheet2!$A:$E,COLUMN(B1),0) Then copy this formula into C1:E1. Hope this helps. Pete On Aug 6, 10:58 am, shrek5000 wrote: 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.
|
|
#4
August 6th, 2008, 01:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return 4 lots of data when a corresponding number is entered
You're welcome, Scott - thanks for feeding back.
Pete On Aug 6, 1:11*pm, shrek5000 wrote: Thanks Pete, it worked just as I had wanted, I just had to change a few cell refrences but it worked a treat, your help is very appreciated Scott
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
