Recent content by Isis5898

Thanks. That worked. I had tried that before, but another part of the formula must have been wrong then. Thanks!

Sorry: =HLOOKUP(Topics!A2,'AGE Data'!$Q$1:$DM$20,19)

1.TOTAL TOPICS MISSED TOPIC 1 TOPIC 2 33 28 31 35 37 33 36 25 1 32 1 31 38 1 41 1 1 44 30 31 1 37 1 35 TOPICS MISSED TOTALS 2 5 <This is row 19> 2.The formula was the HLookup, returning the row # 19 field 3. TOPIC 1 TOPIC 2 TOPIC 3 TOPIC 4 TOPIC 5 TOPIC 6 TOPIC 7...

The VLOOKUP would work if the numbers were at the top. I think my boss is trying to use vertical columns to return horizontal numbers. He doesn't want to transpose or move anything around. I tried that already for the HLOOKUP and it worked. He is just convinced that it should work his way...

But the value that I am trying to return is horizontal, does that matter?

This would probably be easier to describe if I could give you the spreadsheet, but here goes. We have a workbook that contains several sheets. One of them is called topics. In the A column it has (vertically) listed Topic 1, Topic 2 and so on. In column B it has a description of each topic...

There is a website that lists all of the .CSS components and extra Webparts that you can download. It is: www.sharepointcustomization.com Hope it helps!

Thanks! Worked like a charm!

I have a report with some complex sorting involved. Is there an easy way to just add an unbound text box to the report that would consecutively number 1,2,3...as the lines of the detail section change? Thanks!