Macro code using IF case with variable inputs for logical test condition

My aim is to take a item from column x and do a lookup in different sheet and if we have match, take the result which needs to be checked with a value in a cell in current sheet. If this passes do the action else return 0.

My formula is

x=76
Temp="$" Chr(x) & 6
Cells(Emp_Tag, Date_Tag) = "=IF(Temp=(VLOOKUP($B" & Emp_Tag & ",'Data'!A1:I" & Rows_From & ",3,FALSE)),'Data'!H" & Rate_Count & ")"

Where 
Cells(Emp_Tag,Date_Tag) - Final cell on which target needs to be filled.
Temp - Cell in current Sheet.[Contains date]
VLOOKUP(...) takes a Id goes to Data Sheet and if found match return corresponding third column value[A date value]

Problem is that When I use F6 instead of Temp its doing fine, if i use variable 'Temp' its printing 'Temp' instead of F6 as i have Assigned F6 to Temp. so formula fails... Please help what i am doing wrong.

Thanks,
Mk

Just another query in same line.

Cells(Emp_Tag, Date_Tag) = "=IF(" & Temp & "=(VLOOKUP($B" & Emp_Tag & ",'Data'!A1:I" & Rows_From & ",3,FALSE)),?????)"

Here VLOOKUP takes input as Id[B*] and checks in Data Sheet and if found returns 3rd column[Date] which is compared with temp.
Here if this is true, the action to be done is to fetch corresponding 6th column.[ I mean the row in which Id matched and Temp equals fetch its corresponding 6th column] What needs to be done here ??

Hope I am clear.

Thanks,