I need to lookup two column and based on value in column-1, Text in column-2 to be copied and pasted in column-3(For all next higher value of column-1 ) until the column-1 value get repeat.
Example in image.
Capture.JPG
As shown in image Column-1(D7) have the text F in column-2 which need to be pasted in column-3 wherever next higher value (ie 3 for 2 which is in column-1) of column-1 is available until column-1 value 2 gets repeat.
Same Should be repeated for entire column-3.
Thanks in advance
Last edited by raghumech; 06-08-2018 at 02:39 AM. Reason: Update in image
If I understand correctly what you want, Column 1 contains a duplicate of number 2 next to Column 2 (letter E), yet letter E is not displayed in Column 3? Only the next duplicate showing F.
Maybe attach a workbook rather than an image.
Letter E would have displayed If there is any value of 3 (Which is next higher of 2) available in the range of 2-2(D6-D7)...As like the range of 2-2 (D7-D25)
Hello raghumech and Welcome to Excel Forum.
The following formula, pasted into cell F3 and dragged down to F30, yields the same values as are shown in column F of the first attached screen shot:Formula:
Please Login or Register to view this content.
For future reference please upload a sample spreadsheet (rather than a screen shot) by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thanks a lot...It worked
I am new to this forum...was searching for uploading file option...thanks for the path
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you have a blessed day.
Hi...I am getting some issue in the solution you have provided...Attached the Spreadsheet for your reference highlighting the issue...Also shown image below for quick view.
Forum Discussion.JPG
Paste the following into cell D5 and double click the fill handle to copy down the column:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Thank you...worked
Very good to hear. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks