# VLOOKUP to retrieve specific sub cell value

1. ## VLOOKUP to retrieve specific sub cell value

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

2. ## Re: VLOOKUP to retrieve specific sub cell value

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!

3. ## Re: VLOOKUP to retrieve specific sub cell value

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.

``Please Login or Register  to view this content.``
Put that in B2 on your Result tab then copy down.

4. ## Re: VLOOKUP to retrieve specific sub cell value

Thanks a lot brother. It really helped me.. I am very much thankful to you

5. ## Re: VLOOKUP to retrieve specific sub cell value

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

6. ## Re: VLOOKUP to retrieve specific sub cell value

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.

7. ## Re: VLOOKUP to retrieve specific sub cell value

Worksheet name : Result

Cell B2 formula , Drag down

HTML Code:
``=INDEX(Product!\$E\$5:\$E\$19,MATCH(A2,Product!\$A\$5:\$A\$19,)+MATCH("Price after revert",Product!\$D\$5:\$D\$19,)-1)``

9. ## Re: VLOOKUP to retrieve specific sub cell value

You're Welcome. Thank You for the feedback

There are currently 1 users browsing this thread. (0 members and 1 guests)