Re: $$Excel-Macros$$ Lookup a name and return a value

2011-02-22 Thread ashish koul
hi marcus see the attachment i tried to solve it with formulae let me know if you require the macro for it. On Tue, Feb 22, 2011 at 2:44 PM, Marcus wrote: > Hi > Can anyone assist me, fixing this macro? I want it to lookup each name > in Sheet1, find it in Sheet2 and return the ID number to Shee

$$Excel-Macros$$ Lookup a name and return a value

2011-02-22 Thread Marcus
Hi Can anyone assist me, fixing this macro? I want it to lookup each name in Sheet1, find it in Sheet2 and return the ID number to Sheet1. The challenge is that the name lookup shouldn't be exact, i.e. "lisa flisa" equals "lisa". *Sheet1* Column C Column F NameID kalle balle li