Hi everyone
I am using the code below to do a vlookup on a product code entered on sheet 'Dashboard', and then matching this product code on a separate sheet and pulling the matching cost through on 'Equipment Cost Lookup'.
The code I am using below works fine, but what I am trying to achieve is to update the code to include an if statement so that if it cannot match the product code in cell G46 to a product code in the table being looked up in 'Equipment Cost Lookup'!C7:E100' then I want to show text 'NOT FOUND' in cell J46 rather than it just staying blank as it currently is if it cannot match the product code in the VLOOKUP.
Is anyone able to help please? I hope this is a simple amendment but I cannot get my head around what code I need to add here.
Thank you in advance.
I am using the code below to do a vlookup on a product code entered on sheet 'Dashboard', and then matching this product code on a separate sheet and pulling the matching cost through on 'Equipment Cost Lookup'.
The code I am using below works fine, but what I am trying to achieve is to update the code to include an if statement so that if it cannot match the product code in cell G46 to a product code in the table being looked up in 'Equipment Cost Lookup'!C7:E100' then I want to show text 'NOT FOUND' in cell J46 rather than it just staying blank as it currently is if it cannot match the product code in the VLOOKUP.
Code:
=IFERROR(VLOOKUP(G46,'Equipment Cost Lookup'!C7:E100,3,FALSE),0)Is anyone able to help please? I hope this is a simple amendment but I cannot get my head around what code I need to add here.
Thank you in advance.
