View Full Version : [SOLVED:] Reverse Lookup Last Record Ignoring Location 300
CCkfm2000
04-04-2008, 02:50 AM
Hi Excel Guru's,
I have a spreadsheet that I need to Reverse Lookup Last Record Ignoring Location 300.
I've attached a copy of the spreadsheet.
Lookup the value in A12 and retrieving the result in AS12 from the Inven1 sheet
Thanks
Krishna Kumar
04-04-2008, 04:57 AM
Hi,
=LOOKUP(2,1/((Inven1!$B$2:$B$4377=A12)*(Inven1!$A$2:$A$4377<>300)),Inven1!$A$2:$A$4377)
HTH
CCkfm2000
04-04-2008, 05:16 AM
Hi,
=LOOKUP(2,1/((Inven1!$B$2:$B$4377=A12)*(Inven1!$A$2:$A$4377<>300)),Inven1!$A$2:$A$4377)
HTH
Wow that's good.
just a small change <>300 to <>"300"
this now works
thanks just about to some more test. will update you soon.
thanks again.....
mdmackillop
04-04-2008, 05:20 AM
Hi Krishna,
Can you explain the logic of your function?
Shazam
04-04-2008, 07:36 AM
Hi Krishna,
Can you explain the logic of your function?
Hi mdmackillop
http://www.mrexcel.com/forum/showpost.php?p=492425&postcount=9
mdmackillop
04-04-2008, 10:18 AM
Thanks Shazam
Great link.
CCkfm2000
04-04-2008, 11:05 PM
thanks all...
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.