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 |
#11
|
|||
|
|||
Lookup/multiple
"Biff" wrote:
I did shorten the formulas a little by using sheetnames: X, Y instead of: Sheet1, Sheet2 g) Those should be mandatory sheet names! Ahh, those are default sheetnames but we can always be creative g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#12
|
|||
|
|||
Lookup/multiple
Appreciate all your help
Thanks. "Max" wrote: "Biff" wrote: I did shorten the formulas a little by using sheetnames: X, Y instead of: Sheet1, Sheet2 g) Those should be mandatory sheet names! Ahh, those are default sheetnames but we can always be creative g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#13
|
|||
|
|||
Lookup/multiple
You're welcome (from us) !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Minerva" wrote in message ... Appreciate all your help Thanks. |
#14
|
|||
|
|||
Lookup/multiple
I have a similar situation
i have one tab labeled "Schedule" that has a list of names in column E3:E10000, a list of cities in column F3:F10000, a list of states in column G3:G10000, and a list of numbers in column C3:C10000 Then on another tab labeled "Calculations" i have each city listed once in column C3:C114, followed by its state in column D3114, and a number in cell A1 I want the Calculations tab to find all names with that number in A1, in the city and state on the row it is on, and list them horizontally in the same row from columns G:P (max of 10 names) I edited the formulas above to look like this: INDEX(Schedule!$E$3:$E$10000,SMALL(IF((Schedule!$C $3:$C$10000=$A$1)*(Schedule!$F$3:$F$10000=$C4)*(Sc hedule!$G$3:$G$10000=$D4),ROW(Schedule!E$3:E$10000 )-ROW(Schedule!E$3)+1),COLUMNS($A:A))) I entered it as an array formulas and expanded the array over to column P and down to row 114 and entered as array again ... but populates the same name in every cell in that range (the first name it found) Any help on what I am doing wrong? "Max" wrote: You're welcome (from us) ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Minerva" wrote in message ... Appreciate all your help Thanks. |
|
Thread Tools | |
Display Modes | |
|
|