i want to find the value of adjacent row using vlookup my answer should
come3 in this case but its not showing that
On Thu, Nov 12, 2009 at 12:42 PM, Aindril De aind...@gmail.com wrote:
Hi Ashish
=IF(EXACT(F7,VLOOKUP(F7,A5:B7,1,1))=TRUE,VLOOKUP(F7,A5:B7,1,1), NO EXACT
MATCH)
Is the
Dear Ashish perhaps you need this.
Chandra Gupta
On Thu, Nov 12, 2009 at 2:18 PM, ashish koul koul.ash...@gmail.com wrote:
i want to find the value of adjacent row using vlookup my answer should
come3 in this case but its not showing that
On Thu, Nov 12, 2009 at 12:42 PM, Aindril De
Sorry for the misunderstanding Ashish. Following is teh correct formula:
=IF(EXACT(F7,VLOOKUP(F7,$A$5:$B$7,2,1))=TRUE,VLOOKUP(F7,$A$5:$B$7,2,1), NO
EXACT MATCH)
Regards,
Andy
On Thu, Nov 12, 2009 at 3:48 PM, ashish koul koul.ash...@gmail.com wrote:
i want to find the value of adjacent row
hi sir
can u please check whats wrong in the formual want to do case sensitive
vkooup
thanks
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at