Extract a single value from a list of values

[groundin]

Currently I have

Please Login or Register  to view this content.

and it works, but I copy it down over 35 cells, G8 to G42. I get the correct answer but I need to extract the value into a single cell lets say AC42 so I can use that value on other sheets to tell which piece of equipment is being utilized.
Thanks in Advance

[63falcondude]

Just FYI: Since you have Excel 2010, your existing formula can be shortened using IFERROR.

=IFERROR(INDEX(Inventory!$F$32:$F$37,MATCH(G8,Inventory!$F$32:$F$37,0))),"")

This can be shortened further to this:

=IF(COUNTIF(Inventory!$F$32:$F$37,G8),G8,"")

That being said, I do not understand what it is that you are looking to do. Which value do you want to extract to AC42? Is there only one output of the formula that isn't blank?

[groundin]

Ok, give me a minute, I just wrote out the explanation and then hit the wrong button and lost it.

[groundin]

Column G (G8:G42) has inventory items by Serial Number. I am looking to find a specific serial number from Inventory F32:F37 in the G8:G42 list.
ex. serial numbers on inventory page are 1, 2, 3, 4, 5, 6. In Cell G24 there is the serial number 3. I have my formulas in Column AB1:AB35. so in this case the output of 3 resides in AB13. How do I get it to give me that single serial number no mater where it is output in AB1:AB35? I would like for example for that value (3) to be out put to a single cell, AC1 so i can extract it to other areas of the workbook.
Hope this helps.

[63falcondude]

I am having a hard time picturing the layout of your workbook. Can you upload an example of your data along with the desired end-result (manually entered) of the formula?

[groundin]

ok here is the attachment. Note AC1 is were i would like the output, i just manually typed it in.

[63falcondude]

Try this in AC1

=LOOKUP(2,1/(AB:AB<>""),AB:AB)

Just keep in mind that you're playing with fire referring to merged cells in formulas.

[groundin]

Works Perfectly!, Thanks!

[63falcondude]

You're welcome. Happy to help.