- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET

Subject: | IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET |

Posted by: | Serge |

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

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(C48)/(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?

- Re: IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET posted by MAX on Mon, 22 May 2006
- Re: IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET posted by Biff on Tue, 23 May 2006