#N/A problem

  1. Posts : 174
    microsoft windows 10

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

    #N/A problem-capture1.png
      My Computer

  2. Posts : 174
    microsoft windows 10
    Thread Starter

    Sorry,, I have found what I did wrong, I should have had the hlookup value on the top row. Sorry again.
      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 15:54.
Find Us

Windows 10 Forums