I've got a great report on Spiceworks that gives detailed information about memory in machines and how many banks are free etc. I've exported this to CSV but what I'd really like is a formula which goes through each entry and calculates how much it'd cost to upgrade according to Crucial.

Name Model Memory Free Bank Upgrade Cost PC1 Optiplex 320 1024 0 PC2 Optiplex 360 2048 1

So what I want is a formula that will look at the model, then the memory then the free banks and if all three meet certain conditions it takes data from sheet 2, which contains the data from Crucial.

So for example If column B = "Optiplex 390" AND column C < 2048 AND column D = 0 THEN insert data from sheet2 Cell XX

I'm not expecting someone to present me a formula, but if you could point me in the right direction i'd really appreciate it.

Thanks