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]

There was an extra ")" in the formula after the zero.

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

 

[Yury1979]

There was an extra ")" in the formula after the zero.

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

Stange, but the amount stays in 0.00, doesn't matter what I do...

 

[Yury1979]

All 0.00

 

[bstory84]

So now that there is no error. . back to my previous question.
Is the correct value showing for the dropdown selection when you remove the "*C9" from the formula?

 

[Yury1979]

So now that there is no error. . back to my previous question.
Is the correct value showing for the dropdown selection when you remove the "*C9" from the formula?

Yes, if I remove C9, the numbers are correct, but there is no C9 involved...

 

[bstory84]

Awesome. is the value in C9 a number or possibly a number stored as text? Double check by doing something simple like =sum(C9) and see if it displays the correct number or a zero.

 

[Yury1979]

Awesome. is the value in C9 a number or possibly a number stored as text? Double check by doing something simple like =sum(C9) and see if it displays the correct number or a zero.

It shows 0, I just put it in a random cell...

 

[Yury1979]

It shows 0, I just put it in a random cell...

Sorry, a proper formula. But same result, 0

 

[Yury1979]

Sorry, a proper formula. But same result, Done. The problem was that C9 & B9 were merged cells, thats wy ot was not showing properly.

 

[Sufiyan97]

That means C9 stored as text just multiple C9 by 1 that is =C9*1 in any of the cell and then copy that value in C9