LinkBack URL
About LinkBacks
Solved It.
Solved It.
Last edited by Pontiac; 10-04-2015 at 07:52 PM.
Hi and welcome to the forum.
Pictures are rarely much use. Please upload the workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Toatlly agree that we need a sample workbook, rather than a pic.
However, you your "supplier in teh 2nd pic - yellow highlight - has the same amount of rows each time ("for Confucion/Purchase/etc") then you could use INDEX/MATCH, something like...
=INDEX('supply Data'!$G:$G,match($D$6,'supply data'!$C:$C,0)+4)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
attached workbook
Did you try my suggestion?
I noticed that I had 1 reference wrong...
=INDEX('supply Data'!$G:$G,match($c$6,'supply data'!$C:$C,0)+4)
That worked! turns out that I was just using match index wrong the whole time
Happy to help
Pontiac,
why did you delete your original question after getting answer?
Point of public forum is that everyone has benefits of it.
You are willing to ask for help and get one but you are not willing to share solution with others?
That's sad
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks