+ Reply to Thread
Results 1 to 4 of 4

Write Vlookup Value To Cell

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Write Vlookup Value To Cell

    I am trying to use this syntax, but I am getting an 'object required' error

    How should I change this syntax so that it will store my vlookup value in a cell and write that value?
    Please Login or Register  to view this content.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Write Vlookup Value To Cell

    Try changing this
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Write Vlookup Value To Cell

    @ alansidman
    You mean
    Please Login or Register  to view this content.

+ 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. [SOLVED] How to write an array formula with vlookup
    By bberger1985 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2014, 10:35 AM
  2. If VLookup contains a certain string, write X inside a cell, or Y if not.
    By pgjsdyma in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-25-2013, 02:59 AM
  3. Replies: 5
    Last Post: 06-21-2013, 12:54 PM
  4. How to write a vlookup macro
    By DaVihm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2013, 06:07 PM
  5. macro to write the vlookup
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2011, 12:17 AM
  6. VLOOKUP to write name of month in a cell
    By BeerKing in forum Excel General
    Replies: 11
    Last Post: 01-11-2011, 03:28 PM
  7. [SOLVED] How can I read & write in a Vlookup cell (same as editing an Acces
    By Bakhsh_UOP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2005, 01:55 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