If Statement Help...

**bermandl** · 10-25-2011, 06:19 AM

Dear All,

I need help figuring out how i would write a formula that would automatically input the price change registered in a different sheet within the same document.

In Iron-Ore, you have different grades of Fe and those represent different prices based on how high Fe content is.

Based on the example provided, what i'm trying to figure out is say if I change the D4 to 58/58, how can I write a formula in I4 that will refer to the "Quick Price" Sheet and find the price for 58/58 and list it in I4? Note: The same grade may not always be in that cell which is why it has to be based on an array of some sort... At least i would imagine, i just can't code it..

Please help!

Thank you,

DLB

**beaunydal** · 10-25-2011, 06:52 AM

maybe...
=VLOOKUP(D4,'Quick Price'!$A:$D,4,0)
assuming the price is in column D under the "Price FOB" heading.

Beau Nydal

**arthurbr** · 10-25-2011, 06:53 AM

In I4 perhaps

Please Login or Register  to view this content.

Values not found will leave a blank cell

**bermandl** · 10-25-2011, 07:15 AM

Thx guys, worked like a charm. I am honestly amazed by how prompt the responses have been, and above all, helpful!

I have been learning a great deal and will rave about this forum to any one struggling with excel.

Thanks again lads.

Best,

DLB