Home |
Search |
Today's Posts |
#1
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA | Excel Worksheet Functions | |||
return a portion of data entered into a cell | Excel Discussion (Misc queries) | |||
Return employee name when the employee's number is entered | Excel Worksheet Functions | |||
When opening a file how to return to where you last entered data | Excel Discussion (Misc queries) | |||
How to return a dollar value for a part number entered in a cell | Excel Worksheet Functions |