vba to use vlookup on two ranges

Hi

I am having trouble finding a solution and i hope you guys can help.
i have a workbook that i need to automate the population of a name on the overview sheet based on a specific character placed in a range. the overview is split in to 3 following sheets i want to cross reference the charaacter 'R' with the headerr/1st row in the named range, match with the named rang on the overview and extract the corresponding name, then paste in to the resposible column on the matching line on the overview

Originally Posted by Bernie Deitrick

You really need to explain what you want with specific examples and names of ranges and addresses of cells, along with examples of input values and expected outputs.

Sorry i have filled in the stakeholders section at the bottom of the first Sheet, and the first two lines of the resposible section along with the first 2 lines of the second sheet named 1.planning.
where the zeroes are relate to the sheet the responsible person need to be copied from. what i want it to do is :

1. find the 'R' on the RACI matrix
2. cross reference with the header to find the stakeholder from the section at the bottom of the sheet.
3. find the relative line on the overview sheet
4. Find the correct row using the project managment column
5. paste the name in the responsible column based on the project management column.

I will probably use a command button to update once a section has been updated but am open to ideas on easier ways to manage the updating

Hope this is a bit clearer

Fair enough, Thanks for looking for me

I have come back to this and converted the sections that need refering to into tables and worked out the logic that i think the vba needs to follow. the cell references i have filled in manually so there is a representation of the data that i need to be populated, i just have no idea where to start writing the code. the following is the logic i think it needs to follow and i have re-uploaded the document:

Sheet "1.Planning" go to second row of "RACIplan" table (C13) and search row for "R"
when found Check row 11 for value of matching column (cell F11 "Product Manager")
sheet "Overview" find previous match ("Product manager") in range "RACI_Stakeholders" (C131:D141 "Product Manager") offset 1 column and copy name ("Doug")
Sheet "1.Planning" go to second row of "RACIplan" table (C13) and match value in column 1 ("Generate business case") to sheet "Overview" Table5 column 1 (C23) offest 5 columns paste copied value ("Doug") to column (cell G23)
loop for each row in sheet "1.Planning"

Sheet "2.Execution" go to Third row of "RACIexec" table (C13) and search row for "R"
when found Check row 11 for value of matching column (cell G11 "Product Manager")
sheet "Overview" find previous match ("Product manager") in range "RACI_Stakeholders" (C131:D141 "Product Manager") offset 1 column and copy name ("Doug")
Sheet "2.Execution" go to Third row of "RACIexec" table (C13) and match value in column 1 ("Update business case") to sheet "Overview" Table5 column 1 (C33) offest 8 columns paste copied value ("Doug") to column (cell J33)
loop for each row in sheet "2.Execution"

Sheet "3.Finalizing" go to Third row of "RACIfin" table (C13) and search row for "R"
when found Check row 11 for value of matching column (cell G11 "Product Manager")
sheet "Overview" find previous match ("Product manager") in range "RACI_Stakeholders" (C131:D141 "Product Manager") offset 1 column and copy name ("Doug")
Sheet "2.Execution" go to Third row of "RACIfin" table (C13) and match value in column 1 ("Update business case") to sheet "Overview" Table5 column 1 (C33) offest 11 columns paste copied value ("Doug") to column (cell M33 )
loop for each row in sheet "3.Finalizing"