finding correct values for appointed cells from other tables

Hi all, Im struggling to figure out how to do this, I have a list of people's local time zone & made a table in a timeline style where I put 1's & 0's as value & using that to graph a chart, att he same time Im also trying to make another table next to it that is the conversion time zone of mines (GMT-8), where I already had formulas in each cell telling me what time the appointed cell would be. However, Im trying to convert that conversion table into same tyle as my 1st table where I use 1's & 0's, so that I can graph a chart of all people compare into my time zone.

At first I tried using HLOOKUP, but it didnt work. it wont see the value. Im hoping if any of u maybe have a better idea than mines or able to correct my HLOOKUP usage method. attached is the worksheet Im working on. The final product I want is the 3rd table on the right where it say "Based On GMT-8 time line. Right now those empty cells & some are manually put in, what I want is to have a formula or some sort method that can auto lookup values comparing the conversion table & local timeline table & put the correct 1's & 0's.

Any help would be appreciated.