Hi,

I have a sample file that is attached to this post that is basically a scaled down version of what I am trying to do.

I am looking to return a price from sheet 1(pricing table) into a column("What it should be") in sheet 2(raw data) given criteria in the raw data. Line 1 of the raw data shows that we need to return the price for Product FRO for JJJ company shipped by JR's and obviously I would want this formula or macro to return the correct value for each line not just the one.

My only idea so far is making a really long IF statement formula, but when I use this on my real data that won't work there are just too many variables. I am sure there is a much easier and far more efficient way of doing this.

Please let me know if more info is needed to help answer this question.

Thanks in advance!

Attached Files

Sample File(Egus fee test).xls (26.5 KB, 13 views)