Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread krishnanm2006
Awesome... Thanks Noorian Best Regards! Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Mon, 21 Nov 2011 12:35:25 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread NOORAIN ANSARI
Dear Krishnan, I hope your query will be solve by =LOOKUP(G3,B3:D11) On Mon, Nov 21, 2011 at 12:22 PM, NOORAIN ANSARI wrote: > Dear Krishnan, > > Don & SAM's solutions are excellent. > apart of this you can also use > =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) > =INDEX($D$3:$D$11,MATCH(G3,$B$3:$

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread NOORAIN ANSARI
Dear Krishnan, Don & SAM's solutions are excellent. apart of this you can also use =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) =INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0)) =OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread dguillett1
Works for me tooo... Don Guillett SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Sunday, November 20, 2011 12:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell between a range of values Here the attachment with the formula Don was

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread Krishnan Moorthy
Sam and Don... Thanks so much!! I never knew that this could be solved using a simple vlookup :) I thought that some nested formula should be written to solve this...Thanks once again.. Warm Regards ! On Mon, Nov 21, 2011 at 12:13 AM, Sam Mathai Chacko wrote: > Here the attachment with the f

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread Sam Mathai Chacko
Here the attachment with the formula Don was mentioning. Working fine as far as I can see! Sam On Mon, Nov 21, 2011 at 12:10 AM, Krishnan Moorthy wrote: > Don, thanks for your response.. > > I have tried Vlookup.. if I enter 99 in G3 it shows NA.. > > Let me rephrase my question once again...If

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread Krishnan Moorthy
Don, thanks for your response.. I have tried Vlookup.. if I enter 99 in G3 it shows NA.. Let me rephrase my question once again...If I enter any number between 1-900 it should pick the corresponding Value .. for example. if I enter 650 it should lookup for this value in my range (B3:D11) and it s

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread dguillett1
Have you tried? =VLOOKUP(G3,$B$3D$11,3) Don Guillett SalesAid Software dguille...@gmail.com From: Krishnan Moorthy Sent: Sunday, November 20, 2011 11:43 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Lookup for a cell between a range of values Dear Excel Gurus, Need your help