Need values to be automatically inserted

Originally Posted by TMShucks

I think you need VLOOKUP or INDEX/MATCH as the basis for your search.

You could upload a sample workbook with an indication of what your desired output is and I'm sure someone will provide an answer (without trawling the web)

Regards

Hi,

Thanks.

I'm attaching a simplified version of the sheet (I've deleted columns unaffected by this query).

I need the price in column D to pop up automatically. Excel would need to 'know' that customer Exo pays 33 cents for item number P4970 in size 20.5 but customer Kaz pays 30 cents for the same item in the same size.

In the meantime I will look up and learn about VOOKUP and INDEX/MATCH (looks scary! lol).

FYI in case anyone's interested, the items in question are buttons and little bits of trimmings that go onto clothing .... hundreds of the darn things!