Cell reference / /another sheet //

[Yury1979]

Hi guys,

Dropdown list created on A15 (screen 1, sheet "Price Quote")
The price should reflect in H15 (screen 1, sheet "Price Quote")
All the data, screen 2, sheet 'Settings"

Can the data from screen 2, be linked to F8 (international of DOmestic flight, screen 3, sheet "Price Quote") and display the price in H15?

Thank you.

 

[bstory84]

Hi Yury! Try this.
put this in cell H15

=VLOOKUP($A15,Settings!$A$385:$C$399,IF($F$8="Domestic",2,3),0))

 

[Yury1979]

9Hi Yury! Try this.
put this in cell H15

=VLOOKUP($A15,Settings!$A$385:$C$399,IF($F$8="Domestic",2,3),0))

Great job, thanks.

Another question. Is there any possible way to link H15 with the number of hours that will be placed manually in C9?
Or maybe you will have to change the entire formula, or maybe it just won't work at all...

 

[Sufiyan97]

Great job, thanks.

Another question. Is there any possible way to link H15 with the number of hours that will be placed manually in C9?
Or maybe you will have to change the entire formula, or maybe it just won't work at all...

How you want to link C9 with H15
do you want to multiple C9 with H15?

 

[Yury1979]

How you want to link C9 with H15
do you want to multiple C9 with H15?

Yes, that's the idea. Is it impossible?

 

[Sufiyan97]

Try

=VLOOKUP($A15,Settings!$A$385:$C$399,IF($F$8="Domestic",2,3),0)*$C$9

 

[Yury1979]

Try

=VLOOKUP($A15,Settings!$A$385:$C$399,IF($F$8="Domestic",2,3),0)*$C$9

Nope, it shows 0,00. I guess it's a good thing, at least it doesn't know error, lol

 

[Sufiyan97]

What result gives if you use just

=VLOOKUP($A15,Settings!$A$385:$C$399,IF($F$8="Domestic",2,3),0)

 

[Yury1979]

What result gives if you use just

=VLOOKUP($A15,Settings!$A$385:$C$399,IF($F$8="Domestic",2,3),0)

It works, but independently of C9. I change the number of parking hours in C9, and the amount in H15 is not changing. It changes only if I change the title on the breakdown list A15

 

[bstory84]

If i'm not mistaken you want the number of hours put into C9 to automatically change the selection in A15?
Or is it the other way around? or neither?
Trying to understand how you want the value in H15 calculated.