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. Failed to update the system registry, Please try using REGEDIT

    in Windows 10 News
    Failed to update the system registry, Please try using REGEDIT: [ATTACH]Some users cannot launch programs due to the “Failed to update the system registry” error. There is no specific program associated with the error. You may encounter this error while opening any program on your system. If you cannot use a particular program due to this...

  3. How to use Windows Backup for Organizations

    in Windows 10 News
    How to use Windows Backup for Organizations: [ATTACH]In this post, we will show you how to use Windows Backup for Organizations. Microsoft has recently announced the general availability of its new feature: Windows Backup for Organizations. This feature allows organizations to seamlessly back up Windows Settings and...

  4. A logon was attempted using explicit credentials, Event ID 4648

    in Windows 10 News
    A logon was attempted using explicit credentials, Event ID 4648: [IMG]We stumbled upon Event ID 4648 in the Event Viewer that says “A logon was attempted using explicit credentials”. This is triggered when a process tries to log into an account by providing credentials (username and password) different from those of the currently logged-in...

  5. Microsoft believes that you won't be using a mouse or keyboard anymore in the future

    in Windows 10 News
    Microsoft believes that you won't be using a mouse or keyboard anymore in the future: What is Windows going to look like in five years and how are you going to interact with the computer system? Depending on when you asked that question, you may have received very different answers. Previously core features, like using MS-DOS, installing Windows from floppy...

  6. Does anyone still use the Windows Media player themes?

    in Windows 10 Ask Insider
    Does anyone still use the Windows Media player themes?: [ATTACH] I like to use NVIDIA because I have NVIDIA graphics card in my computer submitted by /u/InfiniteSugar1812 [link] [comments] https://www.reddit.com/r/Windows10/comments/1mi7hbd/does_anyone_still_use_the_windows_media_player/

  7. How to make Stickers on Windows 11 using Paint app

    in Windows 10 News
    How to make Stickers on Windows 11 using Paint app: [ATTACH]In this tutorial, we will show you how to make Stickers on Windows 11/10 using the Paint app. We can do this using a new feature called Sticker generator in the Paint app. It is an AI-powered feature exclusive to Copilot+ PCs that uses a Neural Processing Unit (NPU)...

  8. One Windows 10 feature you use all the time that most people completely overlook?

    in Windows 10 Ask Insider
    One Windows 10 feature you use all the time that most people completely overlook?: I have been using Windows 10 for years, but I still randomly discover small features or shortcuts that make a huge difference in my workflow…like the clipboard history (Win + V) or the Focus Assist mode. It got me wondering: what other underrated or hidden features are...

  9. Computer crashes when using Teams

    in Windows 10 News
    Computer crashes when using Teams: [ATTACH]This article lists some working fixes to help you if your Windows computer crashes when using Microsoft Teams. This problem can occur due to several causes, such as a corrupt Teams cache, a conflicting third-party application or service, or faulty RAM. Computer...

  10. How to use Recall in Windows 11: Detailed Guide

    in Windows 10 News
    How to use Recall in Windows 11: Detailed Guide: [IMG]The Recall feature in Windows 11 is rolling out gradually for general availability. Microsoft Recall, also referred to as Windows Recall, is a native feature that automatically takes snapshots of your screen and lets you search and access those snapshots to find items on...