look for a value

So I need to do a look up. The information below is from two spreadsheets. The look-up equation goes where #n/a is, below Total 87171. My result needs to to be the 2031. I tried using an index-match equation, but it doesn't work for some reason. It might have to do the fact that Total 87171...

Hello all, Any help on solving my excel nightmares would be much appreciated. The relevant columns of my dataset look like this: <tbody> 1 V W X BA 2 50 1 0 51 3 51 0 0 4 52 0 0 5 68 1 0 72 6 69 1 0 7 70 1 0 8 71 1 0 9 72 0 0 10 73 0 0 </tbody> I need a formula that...

I am very new to excel, and i bieleve i am working in excel 2010. I have been given a workbook that has a sheet called State Standards. This sheet contains pre determined goals for the entire year for 9 different offices. Another sheet imports actual month end numbers at the end of every month...

Hello Excel/VBA experts, I am very inexperienced in VBA and wanted to run an idea across you to see if you could provide input on feasibility or to improve upon it with capabilities I may not be aware of. (I already looked, but if you can find something similar to this in another thread, please...

Hello, So I have a problem that I'd rather solve in a formula than write VBA to force what I want... I have an array where I have "Make" and "Model" of certain products with the "List Price" I wrote the formula to find MINimum "List Price" but I need to be able to see which "Make" and...

I need to find the last lot# in Column C of sheet1 and look up for that lot# in Column D of sheet2. Append all the corresponding rows and entries below of that last lot# into sheet1. So far no luck. Can someone please help me with this? Thank you