how ro reference to other sheet with look

[1234]

Hi,

I have sheet1 and Sheet2

In A1 (Sheet1) I want to use this formula =LOOK(G2,{1,2,3},
{100,200,Sheet!D3})

I mean I want to look the G2 value. If it´s 1 return 100; if it´s 2
return 200 and if it´s 3 I want to show D3 (Sheet2) value. My problem
is that the formula I´ve used doesn´t let me reference to sheet2!D3

How can I do this?

Thanks

 

[L. Howard Kittle]

Try this, but may not fit completely into your sheet requirements as
sometimes posters give a over simplified version of the sheet layout and
desired results.

=IF(G2=3,Sheet2!D3,LOOKUP(G2,{1,2},{100,200}))

HTH
Regards,
Howard

Hi,

I have sheet1 and Sheet2

In A1 (Sheet1) I want to use this formula =LOOK(G2,{1,2,3},
{100,200,Sheet!D3})

I mean I want to look the G2 value. If it´s 1 return 100; if it´s 2
return 200 and if it´s 3 I want to show D3 (Sheet2) value. My problem
is that the formula I´ve used doesn´t let me reference to sheet2!D3

How can I do this?

Thanks