I'm creating HTML code with my excel spreadsheet

[AbrahamWalker]

I've been working on using my excel skills to create HTML Code using the concatenate formula. So far, everything is going according to my plans.

My question:

I have 3 worksheets in a workbook.
A. Data
B. Calculations
C. HTML Code

In spreadsheet C, I would like to do a calculation that says,

If a cell in HTML Code matches a cell in Data return a certain value from Calculations.

What formula would I use to complete this task?

Thanks in advance for your help. This forum equipped me with the knowledge I needed to trim hours off of my web page creation task.

 

[Peter_SSs]

If a cell in HTML Code matches a cell in Data return a certain value from Calculations.

Is this an example of what you mean?

If cell D5 in 'HTML Code' matches (equals) cell J2 in 'Data' then return what is in cell B7 of 'Calculations', otherwise return nothing?
If so, in a cell in 'HtML Code' you would use

=IF(D5=Data!J2,Calculations!B7,"")

If that is not what you mean, please give further clarification & examples.

 

[AbrahamWalker]

If that is not what you mean, please give further clarification & examples.

I'll work on a better explanation.