Formula Help Please

[RodDavis]

Hi 

Hope somebody can help me please....

Below is a copy of 3 cells, what I am trying to do is when a 'W' is entered, it auto copies the figures into the blank cell.

£                  9,875.00

W

What is the formula to achieve this please?

[#2 · Accepted solution]

@RodDavis 

In the attached file you can enter "W" in any cell in range H2:H20 and the worksheet.change event will put the value from column F in column G.

In the attached file you can enter "W" in range D2:D20 and the formula below puts the value from column B in column C.

=IF(D2="W",B2,"")

[#3]

@OliverScheurich
Thanks that's perfect