O
OdAwG
Hello All,
I do not understand why this would not work. When I type the following, I
get the #REF error
=MAX(INDIRECT(Brkt1!$D$4,Brkt1!$D$6))
So, I modified the above line with the following, then I get the follwoing
error #VALUE:
=MAX(INDIRECT("Brkt1!$D$4","Brkt1!$D$6"))
What I am trying to do is the get the Max number between two numbers on
another sheet and copy the name of the max number over to the current
sheet.
A B C D E
1
2
3
4 John 190
5
6 Karen 201
7
My original formula is the following:
=IF(MAX(Brkt1!$D$4,Brkt1!$D$6)=Brkt1!$D$4,Brkt1!$C$4,Brkt1!$C$6)
so my result should be Karen in the current sheet.
The above formula works great, but when I delete the sheet called brkt1 and
then re-create it, I get #REF inside the formula where Brkt1 is suppose to
be.
Any and all help in this matter is greatly appreciated
Argus
I do not understand why this would not work. When I type the following, I
get the #REF error
=MAX(INDIRECT(Brkt1!$D$4,Brkt1!$D$6))
So, I modified the above line with the following, then I get the follwoing
error #VALUE:
=MAX(INDIRECT("Brkt1!$D$4","Brkt1!$D$6"))
What I am trying to do is the get the Max number between two numbers on
another sheet and copy the name of the max number over to the current
sheet.
A B C D E
1
2
3
4 John 190
5
6 Karen 201
7
My original formula is the following:
=IF(MAX(Brkt1!$D$4,Brkt1!$D$6)=Brkt1!$D$4,Brkt1!$C$4,Brkt1!$C$6)
so my result should be Karen in the current sheet.
The above formula works great, but when I delete the sheet called brkt1 and
then re-create it, I get #REF inside the formula where Brkt1 is suppose to
be.
Any and all help in this matter is greatly appreciated
Argus