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
