I have a file with two tabs (Final Calc and Initial Data). I am trying to pull back a field from Final Calc based on it matching two data fields on the Initial Data tab. Here is a basic example:
Final Calc Tab
Transaction #/ Price Variance / New Price
123 / 0.125 / 102.00
123 / 0.307 / 101.50
456 / 0.50 / 103.00
456 / 1.25 / 99.875
657 / 0.652 / 98.52
657 / 0.75 / 100.50
Initial Data Tab
Transaction #/ Price Variance(Min)/ New Price
123 / 0.125 / value I want from the other tab
456 / 0.50
657 / 0.652
I have already pulled back the minimum values from final calc tab, I just need to bring in the new price value based on matching to transaction and the price variance on the initial data tab.
I tried using an Index match with two criteria but can't see to get the formula to work. Here is what I had:
=INDEX('Final Calc'!A1:Q21511, MATCH(1,'Final Calc'!A:A='Initial Data'!A2)*('Final Calc'!Q:Q='Initial Data'!P2),0),14)
I need this to be an exact match too. I also did the CTRL SHIFT ENTER when I was done with this but am getting an error saying there are errors in my formula but I can't figure out where I went wrong.
Thank you for the help!!
Bookmarks