Can you please help me to find out the "price after revert" in this price column . Please look into the attachments for more details.
Thanks
Can you please help me to find out the "price after revert" in this price column . Please look into the attachments for more details.
Thanks
Last edited by Learnerhere; 06-29-2021 at 03:31 PM.
reformat your data as attached then a simple vlookup is what you want
and avoid merged cells!
Excel works on simple principle of ONE row per item; avoid "complex" formats as they only make life more complicated.
Keep it simple!
Last edited by JohnTopley; 06-29-2021 at 03:06 PM.
Or you can use INDEX/MATCH and get the price you want like this and not have to change your layout/structure.
Now this will give you the price you want as long as the price you want is 2 rows below the list price.
Put that in B2 on your Result tab then copy down.Please Login or Register to view this content.
If you find the suggestion or solution helpful, please consider adding reputation to the post.
Thanks a lot brother. It really helped me.. I am very much thankful to you
Thanks brother, But i cant do the data arrange for lot of data and it may change the outlet of the sheet also.. Thanks again Brother
As you appear to be relative new to Excel I do urge you to reconsider your decision not to reformat. I see so many people resorting to complex formulae simply because of the way data is organised.
The format has the advantage of simplicity and i would argue it is much more readable. The "pain" now will pay dividends later.
Worksheet name : Result
Cell B2 formula , Drag down
HTML Code:
Thanks Brother, It was helpful
You're Welcome. Thank You for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks