|Subject:||IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET|
|Date:||Mon, 22 May 2006|
The formula below works ok in the first sheet called "Right-Angled Triangle"
In T27 =IF(ISNA(VLOOKUP(S27,Z4:AA84,2,1)),"",VLOOKUP(S27,Z4:AA84,2,1)*P27)
Lookup table is Z4:AA84
But in sheet 2 called "Oblique-Angled Triangle"
a similar formula does not work.
In U48 =IF(ISNA(VLOOKUP("T48,'Right-Angled
I am trying to use the same table for both sheets.
also one more question if it's ok.
I'm not getting the correct answer?
In A48, B48, C48 will be user input which will be empty at the beginning.
The answer to this formula is 21.416 which is incorrect
Oblique Triangle solution:
Side a in A48=25.0
Angle A in B48=79.94 Degrees
Angle B in C48=58.03 Degrees
Side 'b' = a x sin 'B' / sin 'A'
The calculator answer is 21.5407 which is correct.
What am I doing wrong?