Find a values from within a column then return a value

[tearl42]

Ok, I need some help. See my forehead has been flattened by my repeated smashing of it in to my desk.

So here's my issue...

The index tab is a cover sheet for the details tab. I want to find a value in Index column B (eg. index!b3) in Details column G (eg details!G$:G$) and then find the cost of that item (eg. details!d3) and then subtract it from the Budgeted Amount (eg. index!c3). I just can't seem to figure out what the hell I'm doing wrong. I've tried everything from counts to vlookups and none of them have worked.

Attached is the example... Please help and as always, thanks in advance. --Tom

Budget Tracking-Example v0.1 07022012.xlsx

[Paul]

Hi Tom, perhaps try:

=C2-INDEX(Details!$D$3:$D$15,MATCH(B2,Details!$G$3:$G$15,0))

Fill down as many rows as necessary. And adjust your lookup/match ranges to accommodate your actual data table on the Details tab. Hope that helps!

[icestationzbra]

probably an overkill, but just to cover all the bases:

in Index D2:

Please Login or Register  to view this content.

mention the Excel version you are using on your profile.