corrct this formula

  • Thread starter Thread starter 11
  • Start date Start date
1

11

Hi,

I'm not good on excel formulas. even though i knew this i tried to
come with some formula for my excel workbook but it returns #REF.

There is a big mistake but i can't identify it.

=INDIRECT("'sheet1'!D2"),IF(INDIRECT("'sheet1'!D2"="others"),'sheet1'!
E2,1)

Pls Help me on this

Rgds,

Vinou
 
There will be drop down in "sheet1'!D2" with the list of 5 members who
dose this perticular task. in addition to that there is a option of
"others" it will be typed amnually in "sheet1'!E2".

I have 28 sheets like the same and In the summery sheet I created a
table in that i can successd on indirecting D2. my problem is how can
i reffer the E2 when D2 will be "others"

Rgds,
Vinu
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.
 
Try

=IF(sheet1'!D2="others",INDIRECT("'sheet1'!E2"),INDIRECT("'sheet1'!D2"))

although I feel it is missing a cell reference as well.
 
Try this array formula

=IF(ISERROR(SMALL(IF($B$1:$B$20=COLUMN(B1),ROW($A$1:$A$20)),ROW($A1))),"",
INDEX($A$1:$A$20,SMALL(IF($B$1:$B$20=COLUMN(B1),ROW($A$1:$A$20)),ROW($A1))))

copy down and across as required
 
Hi Bob,

Thanks for the help.

This one is perfect for what i needed.

Ah.. u made me to put my thoughts on array formulas by that wrong
post. :)

Thanks,

Vinu
 
Back
Top