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!

--
Attitude is what you decide.