Need a formula

[Uzzal]

I wish If I could get a formula as showed in the excel sheet

When O7 is = C11 the P7 cell will show result of R11
When O7 is = C12 the P7 cell will show result of R12
When O7 is = C13 the P7 cell will show result of R13 & follows

 

[herofox]

hello-you can use this

=IF($O$7=$C11,$R$11,IF($O$7=$C12,$R$12,IF($O$7=$C13,$R$13,"")))

 

[Peter Bartholomew]

I think this is best achieved with a lookup (XLOOKUP for up to date versions of Excel and INDEX/MATCH or VLOOKUP for legacy versions).

= XLOOKUP(O7,C11:C30,R11:R30)

or, better again, , using a Table

= XLOOKUP(
   reportDate,
   Table1[Date],
Table1[Day wise
Total Port &
shipping line
rent in BDT])

 

[bosco_yip]

Or, you can use Vlookup function something like this >>

In P7, enter formula :

= VLOOKUP(O7,C11:R34,16,0)