Windows 10: Using vlookup with if

Discus and support Using vlookup with if in Microsoft Office and 365 to solve the problem; Hi all,,,,, I am trying to retrieve the contents of a cell using vlookup and if, The cell will be either a number, a blank or the # sign. The first... Discussion in 'Microsoft Office and 365' started by donnylad, Nov 20, 2018.

  1. DONNYLAD
    donnylad Win User

    Using vlookup with if


    Hi all,,,,, I am trying to retrieve the contents of a cell using vlookup and if, The cell will be either a number, a blank or the # sign. The first part works ok using iferror and I want the if command to give me "" an empty string when it sees the # sign and that is the bit I get wrong as it will not accept this part.
    Here is my formula:
    =IFERROR(VLOOKUP($B$158,$A$27:$AH$76,$C$156+3,0),"")=IF(VLOOKUP($B$158,$A$27:$AH$76,$C$156+3,0)="#", "")
    It shows me #### or false
    Can someone help me please.
    Len

    :)
     
    donnylad, Nov 20, 2018
    #1
  2. LINLEY MESLIER
    Linley Meslier Win User

    Excel

    According to this article by Microsoft MVP Todd Ogasawara, vLookup is supported by Excel Mobile.
    Even though the aricle applies to Excel Mobile for Windows Mobile 5, I think this functionality should still be present in WM6 and 6.1.

    Have a look at the article. It might help:

    Excel Mobile Quick FAQs
     
    Linley Meslier, Nov 20, 2018
    #2
  3. HOMETOWNNERD
    hometownnerd Win User
    I have a WP7 with the beta of Mango and I am using Skydrive and Excel and have an issue with one excel workbook in particular

    I have a WP7 with the beta of Mango and I am using Skydrive and Excel and it says "Can't edit workbook" What formulas can cause this so that I can get rid of them, I am guessing it is vlookup but that is the whole point of the spreadsheet. Is there a list
    somewhere saying you can use these formulas on excel mobile on WP7?

    Thanks,
    Larry
     
    hometownnerd, Nov 20, 2018
    #3
  4. ROBERT JOHN WEIR
    Robert John Weir Win User

    Using vlookup with if

    Excel

    I cannot get vlookup to work in Excel Mobile 6.1.
     
    Robert John Weir, Nov 20, 2018
    #4
Thema:

Using vlookup with if

Loading...

  1. Using vlookup with if - Similar Threads - Using vlookup

  2. Microsoft Confirms Windows 11 KB5124010 Crashes Games and Apps That Use Dolby Digital Audio

    in Windows 10 News
    Microsoft Confirms Windows 11 KB5124010 Crashes Games and Apps That Use Dolby Digital Audio: Microsoft has confirmed that KB5124010, the September 22, 2026 preview update for Windows 11, can crash some games, media players, and productivity applications that rely on AC-3 (Dolby Digital) audio decoding. The company added the known issue to the Windows release health...

  3. Windows 11 Begins Automatically Indexing Your Most-Used Folders for Search

    in Windows 10 News
    Windows 11 Begins Automatically Indexing Your Most-Used Folders for Search: Microsoft has begun rolling out a Windows 11 Search feature that can automatically add frequently used folders to the operating system's search index. Microsoft says "Windows now automatically indexes your most used folders," putting files from those locations into later...

  4. Use PowerShell OSLicense Module to manage Windows Activation

    in Windows 10 News
    Use PowerShell OSLicense Module to manage Windows Activation: [ATTACH]Microsoft has officially announced that VBScript (Visual Basic Scripting) has been deprecated and will be removed completely from all future Windows versions. VBScript is a scripting language that has been used since 1996 for various Windows tasks. After this update,...

  5. How to enable and use Leo AI on Brave browser on PC or Phone

    in Windows 10 News
    How to enable and use Leo AI on Brave browser on PC or Phone: [ATTACH]Leo is an AI assistant built into the Brave browser. It can answer questions, generate content, summarize webpages, analyze documents, and help with other tasks without requiring you to open a separate AI chatbot. In this guide, we will show you how to enable and use...

  6. How to install and use Gemini CLI on Windows 11

    in Windows 10 News
    How to install and use Gemini CLI on Windows 11: [ATTACH]Gemini CLI brings Google’s Gemini AI directly to the Windows Terminal. Instead of opening a browser every time you want to ask Gemini something, you can run it from PowerShell and use it to work with files, write or explain code, troubleshoot errors, and perform other...

  7. Deploy Known Issue Rollback (KIR) using Group Policy in Windows Server

    in Windows 10 News
    Deploy Known Issue Rollback (KIR) using Group Policy in Windows Server: [ATTACH]In this post, we will see, what is Known Issue Rollback (KIR) on Windows and how to deploy Known Issue Rollback (KIR) using Group Policy on Windows 11 and Windows Server. One constant on Windows 11 is its regular updates. Updates keep our devices secure, add new...

  8. How to enable and use Microsoft iSCSI Initiator in Windows 11

    in Windows 10 News
    How to enable and use Microsoft iSCSI Initiator in Windows 11: [ATTACH]Microsoft iSCSI Initiator is commonly used in enterprise environments to access storage hosted on a Storage Area Network (SAN), an iSCSI-enabled Network Attached Storage (NAS) device, or a Windows Server configured as an iSCSI target. The tool is built into Windows...

  9. Benefits of Using a Repurchase MLM Plan for Network Marketing

    in Windows 10 Software and Apps
    Benefits of Using a Repurchase MLM Plan for Network Marketing: A Repurchase MLM Plan can provide a structured way for businesses to manage repeat purchases alongside member and referral activities. When supported by software, businesses can automate product orders, repurchase tracking, sponsor relationships, commission calculations,...

  10. How to use Claude Code and OpenAI Codex remotely in Windows 11?

    in Windows 10 News
    How to use Claude Code and OpenAI Codex remotely in Windows 11?: [ATTACH]Claude Code and OpenAI Codex can do much more than simply answer coding questions. They can work with files, run commands, change projects, and handle longer development tasks. The problem is that some of these tasks take time, and you may not want to stay seated at...