PDA

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...