#N/A problem


  1. donnylad
    Posts : 176
    microsoft windows 10
       New #1

    #N/A problem


    Hi all,,,I have this sheet of data and for some reason this formula does not work although it does in another sheet and I cannot fathom out why> It seems to look right but it keeps showing this error #N/A.
    =IF(HLOOKUP(Teamsheet!H8,'C2018'!C17:AB20,2,1)="H",'C2018'!C13,HLOOKUP(Teamsheet!H8,'C2018'!C17:AB20 ,3,1))
    H8 has the number 15 in it, C13 has Hawcoat Park, can someone help with this Please.
    Len

    #N/A problem-capture1.png
      My Computer
    Quote Quote

  3. donnylad
    Posts : 176
    microsoft windows 10
    Thread Starter
       New #2

    Sorry,, I have found what I did wrong, I should have had the hlookup value on the top row. Sorry again.
    Len
      My Computer
    Quote Quote

 

  Related Discussions
Hi everyone. Edge has been acting differently for some time. If I click on the usual page in the usual place instead of giving me the usual result, sometimes (1 time out of 10/20 or so), it shows me an advertisement. I didn't worry so much...
My laptop, system one listed in “My Computers” Running Win 10 pro version 2004 (OS build 19041.685). Has an inconsistent occasional boot problem and looking for someone that might be able to guide me where to look that I haven’t already. Things...
Account problem causing Settings Panel Problem
in User Accounts and Family Safety

The Settings panel on my Windows 10 Pro production system opens full screen. I had another thread about the problem and with troubleshooting assistance the problem has been isolated to my Win 10 account. I can create another account and the...
VLC player seems to trigger NVIDIA Shadowplay to think I'm gaming when I go to fullscreen video. This messes up the VLC UI bar and otherwise is problematic as well. Used to be they worked fine together, dunno what happened. I haven't found a...
Password problem or Windows Live Account problem
in User Accounts and Family Safety

Cannot remember password, OR typed it in wrong on both entries. When I use the tool for recovering/resetting the password. The system takes me to a reset function, where I am able to put in a new password twice, but the screen that follows does not...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 01:00.
Find Us




Windows 10 Forums