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 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,...

  3. Hackers Use Fake CAPTCHA To Infect Windows PCs

    in Windows 10 News
    Hackers Use Fake CAPTCHA To Infect Windows PCs: Hackers are using fake CAPTCHA verification pages to trick Windows users into running malicious PowerShell commands that install information-stealing software. The campaign publishes StealC, an information-stealing tool that targets browser credentials, cryptocurrency...

  4. Windows PC is using CPU instead of GPU [Fix]

    in Windows 10 News
    Windows PC is using CPU instead of GPU [Fix]: [IMG]If your Windows PC is using a CPU instead of a GPU, this can ruin your gaming experience, resulting in lower FPS, stuttering, and poor gaming performance. Some users encountered this issue. This article lists working fixes for this problem. PC is using CPU instead of GPU...

  5. How to use PowerToys in Windows 11; Best features

    in Windows 10 News
    How to use PowerToys in Windows 11; Best features: [IMG]If you have installed PowerToys on Windows 11, you might be looking for ways to use it to improve productivity. Therefore, in this guide, we present to you some of the best features of PowerToys and how to use them. Best Features of PowerToys If you want to use PowerToys...

  6. How to use Summarize in Windows 11 Notepad to Enhance Writing with AI

    in Windows 10 News
    How to use Summarize in Windows 11 Notepad to Enhance Writing with AI: [ATTACH]Alongside the recently introduced Write and Rewrite features, Microsoft has now added a Summarize feature to the Notepad app. This new feature allows you to quickly transform long pieces of text into short, high-level summaries, making it easier to review notes,...

  7. How to use Virtual Workspaces settings in Windows 11

    in Windows 10 News
    How to use Virtual Workspaces settings in Windows 11: [ATTACH]In this post, we will show you how to use the new ‘Virtual Workspaces’ settings in Windows 11. In a recent update, Microsoft has introduced a new Virtual Workspaces page that centralizes the management of virtualization-related features directly within the Settings...

  8. How to use AI in Snipping Tool to take Perfect Screenshot

    in Windows 10 News
    How to use AI in Snipping Tool to take Perfect Screenshot: [ATTACH]In this post, we will show you how to use AI in Snipping Tool to take perfect screenshots on your Windows 11 PC. Microsoft has recently added an AI-powered feature to its built-in Snipping Tool, making capturing on-screen content smarter and more precise than ever....

  9. Create real-time interactive flowcharts for your code using VS Code CodeVisualizer

    in Windows 10 News
    Create real-time interactive flowcharts for your code using VS Code CodeVisualizer: [ATTACH]In this post, we will show you how to create real-time interactive flowcharts for your code using VS Code CodeVisualizer. CodeVisualizer is a free, open-source Visual Studio Code extension that transforms code into visual diagrams, making it easier to understand...

  10. How to enable and use Agent in Settings on Windows 11?

    in Windows 10 News
    How to enable and use Agent in Settings on Windows 11?: [ATTACH]In this tutorial, we will show you how to enable and use the Agent in the Settings app on a Windows 11 PC. Agent in Windows Settings is a new feature in Windows 11 Copilot+ PCs that uses on-device AI to find and change settings and get relevant recommendations within...