Reverse Lookup Last Record Ignoring Location 300

[CCkfm2000]

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]

Hi,

=LOOKUP(2,1/((Inven1!$B$2:$B$4377=A12)*(Inven1!$A$2:$A$4377<>300)),Inven1!$A$2:$A$4377) 

HTH

[CCkfm2000]

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]

Hi Krishna,
Can you explain the logic of your function?

[Shazam]

Hi Krishna,
Can you explain the logic of your function?

Hi mdmackillop


http://www.mrexcel.com/forum/showpos...25&postcount=9

[mdmackillop]

Thanks Shazam
Great link.

[CCkfm2000]

thanks all...