#N/A problem


  1. Posts : 166
    microsoft windows 10
       #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


  2. Posts : 166
    microsoft windows 10
    Thread Starter
       #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


 

  Related Discussions
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 08:11.
Find Us




Windows 10 Forums