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. How to install WMIC in Windows 11 using Settings, PowerShell or CMD

    in Windows 10 News
    How to install WMIC in Windows 11 using Settings, PowerShell or CMD: [ATTACH]Windows Management Instrumentation Command-line (WMIC) is a tool introduced by Microsoft for tracking events on a Windows PC, including hardware, processes, settings, and user accounts. The administrator can run WMIC scripts to retrieve data from the system and...

  3. Secure boot is on but your device is using an older boot trust configuration that should be...

    in Windows 10 News
    Secure boot is on but your device is using an older boot trust configuration that should be...: The current set of Secure Boot Certificates will expire in June 2026. After that, users whose computers have the older certificates may encounter boot issues. Also, their devices will become vulnerable to Rootkits. That’s why Microsoft is installing the latest Secure Boot...

  4. Has anyone used LOV111VOL? Is it trustworthy?

    in Windows 10 Software and Apps
    Has anyone used LOV111VOL? Is it trustworthy?: I recently came across LOV111VOL and the concept seems interesting: https://lov111vol.com/digital-binder From what I understand, it’s a portable/self-hosted digital document organizer that can run from external storage. I’m mainly interested in: offline access to...

  5. How to run OpenClaw locally using Discord

    in Windows 10 News
    How to run OpenClaw locally using Discord: [ATTACH]If you are looking for an AI assistant to run locally on your computer, OpenClaw is your answer. It can be directly accessed from your Discord server. In this post, we will see how to prepare your environment, configure a bot token, and run OpenClaw locally using...

  6. How to turn on and use NVIDIA DLSS in a game?

    in Windows 10 News
    How to turn on and use NVIDIA DLSS in a game?: [ATTACH]Are you looking to give your games a massive performance boost without sacrificing visual fidelity? NVIDIA DLSS makes this possible, turning demanding PC games into buttery-smooth experiences. In this article, we are going to see how you can turn on and use NVIDIA...

  7. How to enable, disable, use Copilot Actions in Windows 11

    in Windows 10 News
    How to enable, disable, use Copilot Actions in Windows 11: [ATTACH]In this tutorial, we will show you how to enable, disable, and use Copilot Actions in Microsoft Edge (or Actions in Edge) on a Windows 11 PC. This new feature lets you instruct Copilot to perform simple tasks, such as book an appointment, open a website, navigate to a...

  8. How to use Phone Connection in Copilot with Android Phone

    in Windows 10 News
    How to use Phone Connection in Copilot with Android Phone: [ATTACH]In this tutorial, we will show you how to use Phone Connection in Copilot with an Android phone on a Windows 11 PC. Phone Connection (formerly known as Phone Plugin) is a native feature in the Copilot desktop app. It helps to connect to your Android phone and perform...

  9. Windows 11 Update Brings Taskbar Changes, Lower Resource Use, and Less Copilot

    in Windows 10 News
    Windows 11 Update Brings Taskbar Changes, Lower Resource Use, and Less Copilot: Microsoft has confirmed plans to implement a series of updates to Windows 11 focused on system performance, reliability, and user experience. These updates will be rolled out in preview over the coming months. The effort is internally codenamed Windows K2, according to...

  10. How to use Markdown in Notepad

    in Windows 10 News
    How to use Markdown in Notepad: [ATTACH]In this post, we will show you how to use Markdown in Notepad on a Windows 11 PC. Microsoft has introduced lightweight formatting in Notepad, and it supports Markdown (*.md) files to work directly with the lightweight markup language. Once you enable text formatting,...