I have a software order sheet that has, in column B, a validation list,
comprising 2 entries, a blank entry and a specific software product
(Product X). That way the users can enter their own software product or
select Product X.

Column E (the monthly rate cell) has been left blank for the user to
enter their own rate, but I am trying to get the Conditional Formatting
to populate the cell with a value if Product X has been selected in
column B.

I have entered the following formula in the Conditional formatting but
get nothing in the monthly rate cell when Product X is selected.

=IF(B8="Product X",VLOOKUP(B8,Software_Rate,2,False),0)

I have tried out the formula "stand-alone" and it works perfectly

I am using the VLookup as the software selection list is certain to
grow.

Can anyone point me in the right direction please.

Regards
Fred