HLookup - Incremental Row additions

Afternoon - I looked and didn't see an incremental row increase request, so I'm posting it here.

I'm updating targets for Q1-Q4 and Fiscal year, which are a total of 6 rows (one in between Q4 and FY). I have 150 managers in my main file, but how can I show for rep 04, all of their targets for Q1-FY, and then follow up with the remaining reps throughout the workbook, without having to manually change the row number?

I've seen various options with the "Row" Function, but for whatever reason, it won't automatically populate throughout the sheet (I think it's because I have 5 separate rows for a single rep before I get to the next rep).

Thank you for any help. File Attached

rO

Thanks for the help, however, the H-N is a different sheet (IE. Sheet 2) - (they are vendors for our business - we have 20 separate tabs). A-E represent the lookup for Q1,Q2,Q3,Q4 and FY17 looking up from the sheet containing columns H-N.

So, what I'm looking for is; AM ID 04 looking up The "Month" (Q1, etc...), to Sheet 2. Sheet 2 contains the amounts that are showing up in Green. I've been using an HLOOKUP, but how can I do this without having to manually change the Row lookup # (i.e. Row 1,2,3,4,5 for Month Periods)?

I hope I'm clearer in my request. ...thanks again for your assistance.

I added another excel example with 2 sheets, similar to my file.

Yes, the layout is identical on the other tabs as well. The "Master Sheet" is the "Results Tab" in the example. The "Data" tab is an example of 1 of the 20 vendors.

End result would be to bring all items into correct placement by not having to change the "row" number for each rep.
Thanks again.

RO

Oeldere,

Sorry for not getting back to you...I tried this, but was unsuccessful, I think I may be overthinking this, but I'm going to try again.

I've attached another workbook that hopefully will help in the understanding of my question.

Reviewing the workbook, tab 1 (Monthly Amt.) is the information I'm looking to bring in from the "Data" tab.
The Data tab figures are horizontally listed across the page, while the Monthly Amt has to be brought in vertically.

So, what my ask is, how can I have AMID 01 tranferred in from Data tab, then AMID 02, etc....AND then switch "vendors" and restart
the count, so I don't have to manually type in each Row.

Please let me know if this can be done with a VBA.

Thank you again, really appreciate your help.

rO

Oeldere,

Your help is greatly appreciated, you've taught me something I wasn't even asking about....In my example (Test #2 workbook), the "AMount COlumn" should have all "blanks" in it to start. What I'm trying to do is to bring in the Horizontal data from the Data tab (monthly values) and bring them into the "Amount" column in the Monthly Amount Tab.

This would benefit from the ROWS formula, but I'm not sure how to use it, since I have AMID's repeating 12 times.

Thanks again