Formula in worksheet event code

[adamsm]

Hi,

How could the following formula be placed in a worksheet event code?

=IF(F21="","",VLOOKUP(F21,Products!$A$3:$E$1329,IF(O$10="Credit",5,5),0))

Column headers are in row 17. And data rows start from row 18.

Any help on this would be kindly appreciated.

Thanks in advance.

 

[GlennUK]

Describe, in words, what you are trying to achieve overall.

 

[adamsm]

What I want in detail is; when I type a code such as 0001 in column F of the sheet “NewOrder”, the Item Category from the column G of the products sheet for that code to get copied to the column H on to the same row(of sheet "New Order").

Any help on this would be kindly appreciated.

Thanks in advance.

 

[GlennUK]

What I want in detail is; when I type a code such as 0001 in column F of the sheet “NewOrder”, the Item Category from the column G of the products sheet for that code to get copied to the column H on to the same row(of sheet "New Order").

Any help on this would be kindly appreciated.

Thanks in advance.

Your description in words does not match your formula. In your formula the furthest right column referenced in the Product sheet is E ( yet you say that you want data from column G returned ).

Also, in your formula, you have some spurious logic:
=IF(F21="","",VLOOKUP(F21,Products!$A$3:$E$1329,IF(O$10="Credit",5,5),0))
The highlighted part does nothing, i.e. it always returns the number 5, no matter what. Why is it in there? Is it a mistake? Should the logic be different?