Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET
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 Triangle'!",Z4:AA84,2,1)),"","VLOOKUP(T48,'Right-Angled Triangle'!,Z4:AA84,2,1)*Q48") 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. In E48 =IF(OR(A48="",B48="",C48=""),0,A48*(SIN(RADIANS(C4 8)/(SIN(RADIANS(B48)))))) 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
Vlookup a part of a cell value in another sheet | Excel Worksheet Functions | |||
Value between 2 dates | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions |