Thanks it worked!!!! On Fri, Jun 18, 2010 at 7:52 AM, gurumurthy sastry Kondury <[email protected]> wrote: > Hi, > > Try using =CONCATENATE(C2&D2) in Column E and then the Vlookup in F. > > It should work. > > Best Regards, > > Guru. > > On Thu, Jun 17, 2010 at 2:54 PM, Regina Medhanie <[email protected]> > wrote: >> >> Thanks you. I try your suggestion and give both cell the same format >> but still I get # N/A. The cell I am refering contains the function >> =CONCATENATE(C2;D2) and even when I use the FIND function I get VALUE >> NOT FOUND evenso I know for sure the value exist. >> >> >> On Wed, Jun 16, 2010 at 2:27 PM, Paul Schreiner <[email protected]> >> wrote: >> > the fact that the cell you're referring to is a function is irrelevant. >> > it should still work. >> > Let's say that you have: >> > A B >> > 1 Jan >> > 2 Feb >> > 3 Mar >> > 4 Apr >> > 5 May >> > 6 Jun >> > 7 Jul >> > 8 Aug >> > 9 Sep >> > 10 Oct >> > 11 Nov >> > 12 Dec >> > >> > and you want to find the month name of the current month >> > (I know, there's other ways of doing this, but this is an EXAMPLE!) >> > say, D3 contains: =MONTH(TODAY()) (displaying "6") >> > then, in E3, you have: =VLOOKUP(D3,A2:B13,2) >> > >> > it'll return "Jun" just like it's supposed to. >> > >> > the #N/A return indicates that whatever you have in the >> > "cell value you're referring to" is not found in the table range >> > you're looking up. >> > >> > make sure the data you're looking for IS actually in the table. >> > and that the vlookup is using the entire table, and the values >> > you're comparing are the same type. >> > (sometimes, numbers in a table that are copy/pasted from another source >> > are actually text strings instead of numeric. if you >> > look for the number 123 in a table filled with TEXT 123, it won't find >> > it!) >> > >> > Paul >> > >> > ________________________________ >> > From: ExcelVBA <[email protected]> >> > To: MS EXCEL AND VBA MACROS <[email protected]> >> > Sent: Wed, June 16, 2010 5:47:40 AM >> > Subject: $$Excel-Macros$$ Help...Vlook up >> > >> > I am trying to use function Vlookup, but the cell value I am refering >> > contains a function and the result I am getting is #N/A , is anyone >> > who knows how I can solve this problem. >> > >> > Regina >> > >> > -- >> > >> > ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to [email protected] >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> > >> > We reach over 7000 subscribers worldwide and receive many nice notes >> > about >> > the learning and support from the group.Let friends and co-workers know >> > they >> > can subscribe to group at >> > http://groups.google.com/group/excel-macros/subscribe >> > >> > -- >> > >> > ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to [email protected] >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> > >> > We reach over 7000 subscribers worldwide and receive many nice notes >> > about >> > the learning and support from the group.Let friends and co-workers know >> > they >> > can subscribe to group at >> > http://groups.google.com/group/excel-macros/subscribe >> > >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to [email protected] >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe >
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
