Formula

Question

Hi All,

I need to create a formula which should be simple I think.

I have 3 sheets. I want sheet 3 to have the formulas on it.

Sheet 3 will need to tell Sheet1 C2 that if a value X appears in that cell, then Sheet1 C3 should equal value X on Sheet2 D2.

I hope that makes sense?

Thanks

Answer 1

In D2 of Sheet1, enter this formula

=VLOOKUP(C2,Sheet2!C:D,2,False)

and then copy down to match column C.

Answer 2

Hi Bernie,

Thanks for the help. I'm still new to formulas and didn't realise you couldn't use a third sheet.

That formula you gave me seems to work for a single cell.

I'll start again. I have two sheets with information. Sheet one has columns C and D which will need different values adding depending on other columns. So, whatever is entered into column c (using a selection list) will determine column D. The values for these columns are on sheet 2 in a table which states value x in one column equals volume x in the next. I've added some screenshots which will hopefully make it a little more clear. These are only examples, obviously.

Thanks

Answer 3

No, what you decribe doesn't make sense: Sheet3 cannot have formulas that 'tell' other sheets to do things. A formula in a cell can only create values in that cell. So if you want Sheet1 or Sheet2 to show a specific values, then formula needs to be on those sheets.

Explain what you want a little more clearly than what you posted:

"Sheet1 C2 that if a value X appears in that cell, then Sheet1 C3 should equal value X on Sheet2 D2"

Maybe, interpreting that as stated, in cell C3 of Sheet1 enter a formula like

=IF(Sheet1!C2="X",Sheet2!D2,"")