D
Dale Long
This is my first time to post a question, so I'm not sure what this
will look
like or if this will look like a spreadsheet.
A value located in columns 2,3, or 4
will identify a value in column 1.
I am trying to solve this problem. The individual formulas
appear to work OK, but when put together
it comes up with '#VALUE!' which according to the tag
is "wrong data type". What is my problem??
How do I solve it??
Given
4 (Column)
Z (Row)
#VALUE! (Answer)
D (Should be answer)
1 2 3 4
A ^ @ ?
B % ! >
C $ P <
D # X Z
2 $D$21:$D$24
3 $E$21:$E24
4 $F$21:$F$24
'=OFFSET($F$24,0,-($B$13-1)) = D
'=INDEX($D$21:$F$24,(4),(3)) = Z
=MATCH($B$15,$F$21:$F$24,0) = 4
'=VLOOKUP($B$13,$C$27:$D$29,2,FALSE) =
$F$21:$F$24
'=OFFSET(INDEX($D$21:$F$24,MATCH($B$15,VLOOKUP
($B$13,$C$27:$D$29,2,FALSE),0),2),0,-($B$13-1)) = #VALUE!
will look
like or if this will look like a spreadsheet.
A value located in columns 2,3, or 4
will identify a value in column 1.
I am trying to solve this problem. The individual formulas
appear to work OK, but when put together
it comes up with '#VALUE!' which according to the tag
is "wrong data type". What is my problem??
How do I solve it??
Given
4 (Column)
Z (Row)
#VALUE! (Answer)
D (Should be answer)
1 2 3 4
A ^ @ ?
B % ! >
C $ P <
D # X Z
2 $D$21:$D$24
3 $E$21:$E24
4 $F$21:$F$24
'=OFFSET($F$24,0,-($B$13-1)) = D
'=INDEX($D$21:$F$24,(4),(3)) = Z
=MATCH($B$15,$F$21:$F$24,0) = 4
'=VLOOKUP($B$13,$C$27:$D$29,2,FALSE) =
$F$21:$F$24
'=OFFSET(INDEX($D$21:$F$24,MATCH($B$15,VLOOKUP
($B$13,$C$27:$D$29,2,FALSE),0),2),0,-($B$13-1)) = #VALUE!