Return Multiple cells dependant on Selection from Drop down list

**Caliga Inicio** · 07-05-2010, 10:18 AM

Hi

I seem to be a bit stuck on the following.

I have created a world cup spreadsheet. On sheet 2 ( Renamed to 'Predictions') i have everyone in my offices predictions that range from cells A1 to E74. I.e See attachment 1.

On Sheet 1 (Renamed to 'Points') i Have a drop down list of Everyones names

What i would like is, if i select Tom from the drop down list to then show anywhere to the side of the drop down list everything from 'Predictions' for Tom. I.e all of Toms Predictions and if i select Paul for it to show all of Pauls predictions exactly as it is on the 'Predictions' Sheet. Hopefully something like Attachment2

I have had a look at VLOOKUP and HLOOKUP but i can only seem to get 1 value returned.

Any suggestions are much appreciated.

Thanks
Tom

**NBVC** · 07-05-2010, 10:25 AM

Select the Range in Predictions sheet A1:G74 and name it through Insert|Name|Define and call it: Tom

Do the same for the other tables naming with relevant names.

Then in the Points sheet:

In D2 enter: =A1

In F6 enter:

=INDEX(INDIRECT($A$1),ROW(A6),3)

and copy down

Then select and copy cell F6 and paste it to H6 and then copy down again.

**Caliga Inicio** · 07-06-2010, 05:04 AM

Hi,

Thanks for getting back to me so quickly.

Unfortunatly both columns of predictions are exactly the same after selecting a name.

Also i get what the formular is doing sort of but im just not sure what the ROW(A6) is doing as there is nothing in that cell.

Thanks
Tom

**Caliga Inicio** · 07-06-2010, 05:30 AM

Ignore Me i was being thick, I just changed the colum number to 5 instead of 3 on the second colum of predictions.

Thanks very much for the help very much appreciated.

Tom