Hello,
I need some help. I attached a document where I explain my problem:
Sheet 1:
Problem
Sheet 2
Full data
Sheet 3:
My numbers
Sheet 4:
How I want it!
Would be great if any one can give me a detailed explenation about how I can fix this!
Thanks in advance!
Need some Inputs:-
1) Are you looking for Formula solution or Macro Code solution.
2) How the values are arrived in sheet3? based on single asterisk in Column-F of sheet2?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
1) Are you looking for Formula solution or Macro Code solution.
The esiest and quickest one! I hope that answer is enough!
2) How the values are arrived in sheet3? based on single asterisk in Column-F of sheet2
I dont quite under stand your question. But I hope this will help you:
Sheet 2 is a list which contains all of my companys products
Sheet 3 is a list of Art nr I get from Marketing. This is a set of products they want in a new campaign. My job is to supplement these Art nr with the data from sheet 2. I got booth sheet 2 and the in simple .xlsx.
Hope this is enough!?
In Sheet4 - A2 cell
Formula:
=IFERROR(INDEX('sheet 2'!$A$1:$F$11,MATCH('sheet 3'!$A2,'sheet 2'!$B$1:$B$11,0),COLUMN(A$1)),"")
Drag the formula down and right.
Adapt the range reference to your data if your data size is higher than the example data.
But where should I do this?
Maybe this is to much work for you, but it would be awesome if you can do a step-by-step guide how you do this?
I don't know how I can help you in further...
1) First select sheet4
2) Then Place the cursor in A2 cell
3) Copy the below formula
Formula:=IFERROR(INDEX('sheet 2'!$A$1:$F$11,MATCH('sheet 3'!$A2,'sheet 2'!$B$1:$B$11,0),COLUMN(A$1)),"")
4) paste the formula (i.e. in A2 cell)
5) Drag the A2 cell down and right to fill it for remaining cells.
edit second try...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks