V Look up highest value
Can some one advise the function to V look up from sheet 2, letter A and paste it into sheet 1 with adjacent value from sheet 2.
See sheet attached
Help much appreciated
Thanks
Martin
Last edited by Martin Chamberlin; 07-06-2011 at 04:27 AM.
try this in A1
Ctrl + Shift + enter not just enter{=MAX(IF(Sheet2!B1:B9=B1,Sheet2!A1:A9))}
Last edited by grizzly6969; 07-06-2011 at 03:41 AM.
Cheers Grizzly but the formula returns a zeroOriginally Posted by grizzly6969
do not put the curly brackets in { } you need to use Ctrl + Shift + enter and they will be entered
view your sample sheet here
Last edited by grizzly6969; 07-06-2011 at 03:56 AM.
Again thanks for the help. The value being returned though is 135000. It should be the highest value in the column for A which is 120000.
are you sure there is an "A" in cell B1 or a "B"
I changed it from B to A
Last edited by grizzly6969; 07-06-2011 at 04:19 AM.
Re: V Look up highest value
Sorted. I was looking at B1 on sheet 2. Many many thanks
Martin
glad I could help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks