+ Reply to Thread
Results 1 to 7 of 7

VLookup or IFERROR

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    greece
    MS-Off Ver
    2007
    Posts
    3

    VLookup or IFERROR

    hi all, i have the attached sample file and i would like to do the following:
    if an entry of Sheet2, column A (let's say A55) matches an entry of Sheet1, column A(let's say A12), then copy sheet1, B12 to sheet2,B55


    sample file.xlsx
    Last edited by journeyman77; 02-10-2016 at 10:49 AM. Reason: correcting title

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,229

    Re: what formula to use?

    Try

    =IFERROR(VLOOKUP(A2,Φύλλο1!$A$2:$C$262,2,0),"")

  3. #3
    Forum Contributor
    Join Date
    01-06-2015
    Location
    Huntsville, AL
    MS-Off Ver
    Office 365
    Posts
    185

    Re: what formula to use?

    Try this. Paste in Cell B2 of sheet2 and copy down =IF(A2="","",IFERROR(VLOOKUP(A2,Φύλλο1!A:C,2,0),""))

  4. #4
    Registered User
    Join Date
    02-10-2016
    Location
    greece
    MS-Off Ver
    2007
    Posts
    3

    Re: what formula to use?

    hi, thanks for your reply but that doesn't seem to work.
    In case i am wrong, where i should insert the above suggested formula?

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: what formula to use?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  6. #6
    Registered User
    Join Date
    02-10-2016
    Location
    greece
    MS-Off Ver
    2007
    Posts
    3

    Re: VLookup or IFERROR

    ok changed! sorry for the inconvenience!

    to get back in my request, none of the above suggestion works...

  7. #7
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: VLookup or IFERROR

    I didn't download your file.

    In the suggested formulas, you may have to replace the commas with semi-colons due to regional settings.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1