Results 1 to 3 of 3

Thread: If text function when correct showing a corresponding value

  1. #1

    If text function when correct showing a corresponding value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am looking to make a function where when B2 equals the text in any cell in column A of sheet 2 then it shows the corresponding number in column F of the same row in which it matched. If not then input a zero. Ex. if B2 says McDonalds then of the other page A254 says Mcdonalds, then number in F254 appears. This is what I have so far but could be completely off =IF(B3='Sheet 2'!A:A,'Sheet 2'!F:F,0).

    Any help would be awesome

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    How about:

    Code:
    =IFERROR(VLOOKUP(S2,'Sheet 2'!A:F,6,0),0)
    Cheers,
    Last edited by CheshireCat; 2015-08-11 at 07:12 PM.

  3. #3
    You sir are an all-star.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •