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 <regina.medha...@gmail.com>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 <schreiner_p...@att.net> > 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 <regina.medha...@gmail.com> > > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > > 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 excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > 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 excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> 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
