• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get last value from a vlookup

ThrottleWorks

ThrottleWorks

Excel Ninja
Hi,


I want to get last value from the vlookup.

I have 2 files.


File A, range A1 value is name.

File B, column A, names.

File B, column B, amount.


For example.


Sachin has 3 different amounts in, 1200,1500,1800.

1800 is the last value from the range.


I want a formula which will give me 1800 ( last value) as a result.


Can anyone help me in this please.


P.S. - I will be using this formula in VB.
 
Hi Marc, I do not know this method that is why decided to use vlookup.


Thanks for the help, have a nice day.


Would request you to please explain me this method if you get time.
 
Best is to start reading the VBA help for this easy method

'cause mine is not in the same language ...


After if you have some difficulty within your code, share it and we will advise ...
 
Hi Sachin..


* There was a huge difference between VB & VBA.. :)

* A single character can create big deffrence..

* same for VLOOKUP & LOOKUP

* try and we are here for you.. if needed..


Regards,

Deb
 
Hi sachin

I think below link will help

Try it

https://www.dropbox.com/s/6a60ix27rhd5fip/using%20vlookup.xlsx


I give the solution with one example

thanks to excel forums for link us
 
@ Marc, thanks a lot for the help.

@ Debraj, yes my mistake, I will try this, thanks a lot for the help.

@ Sivakuma, thanks for the link, I am checking this.

@ Vijay, thanks for the link, I am checking this.


Have a nice day to everyone.
 
Hi,


I am not allowed to open "https://www.dropbox.com/s/6a60ix27rhd5fip/using%20vlookup.xlsx


" at office.


I copied (not cross posted) following solution from web.


=LOOKUP(2,1/(A1:A10=C1),B1:B10)


I edited the formula as per my range, it is working.


Link is

http://www.mrexcel.com/forum/excel-questions/201255-vlookup-last-match.html


Thanks a lot to everyone for their help, have a nice day.
 
You must log in or register to reply here.
Back
Top