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

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

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

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

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

  7. How to use MSG.exe to send message to network computer

    in Windows 10 News
    How to use MSG.exe to send message to network computer: [ATTACH]Msg.exe is a command-line message utility in Windows computers that administrators can use to send messages to other users on remote computers on the same network. In this article, I will show you how to use MSG.exe to send a message to a network computer. How to use...

  8. Computer heating up when using Hyper-V

    in Windows 10 News
    Computer heating up when using Hyper-V: [ATTACH]Hyper-V can make your computer run hotter because it allows multiple virtual machines (VMs) to run simultaneously on a single physical machine. This requires significant CPU and memory resources, and the hypervisor must manage resources between the main system and the...

  9. Microsoft misses Windows 10 so badly it’s still using it to promote Windows 11

    in Windows 10 News
    Microsoft misses Windows 10 so badly it’s still using it to promote Windows 11: Microsoft’s support page @MicrosoftHelps accidentally used Windows 10’s graphical UI to showcase the Night Light feature on an X post, even as the OS has already reached end-of-support. Windows 10 has been officially retired on October 15, 2025, but apparently, Microsoft...

  10. How to use Affinity Designer app for free on Windows PC

    in Windows 10 News
    How to use Affinity Designer app for free on Windows PC: [IMG]Affinity, which offers great alternatives to Adobe Photoshop, Illustrator, and Lightroom, is popular for its one-time payment for a lifetime, as opposed to monthly recurring payments for Adobe programs. Affinity Photo and Affinity Designer are widely used by designers...