If statment and procv issue

[distraido]

Hello,
I am trying to to a simple formula to do this.
on sheet one i have 3 colums timezone and time and time2, on sheet 2 i have a table with the value of the timezones ex: timezone france 1h timezone germany 2h and so on, what i an strugling to do is a simple formula that if timezone is france it subtracts the the value of that timezone from time and shows that value on time2.

ex:
Timezone | Time | Time2
France | 12:00 | 11:00
germany | 12:00 | 10:00

[JohnTopley]

Lookup table ...

1st column "Country" , 2nd column "Time Delta"

Please Login or Register  to view this content.

for time2

=B2-VLOOKUP(A2,$F$1:$G$2,2,0)

b2 is Time1

Table in F1:G2

[biggummy]

I don't know if this helps, but as I understand it, I believe this does what you want. I just have a simple sum, so I don't know how you want to implement an IF statement.
Of course, I don't know if you want AM/PM or the 24 hour time. Here you go: =SUM(B2-Sheet2!B2)
File Attached

[distraido]

Lookup table ...

1st column "Country" , 2nd column "Time Delta"

Please Login or Register  to view this content.

for time2

=B2-VLOOKUP(A2,$F$1:$G$2,2,0)

b2 is Time1

Table in F1:G2

it worked fine many thanks