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





:)

 

Windows 10 1709 System Restore problems...


That seems to be an attempt at Option 2 in the tutorial, which requires you to
a. Boot to a command prompt (Did you?)
b. You then seem to be mixing steps 3,4 and 5, thus your command is incorrect.

I suggest Option 1 is easier.

If you still have problems, please repost listing each specific step and saying which option from the tutorial you are using. Thanks.

 

How to factory reset Cisco 1700 Router

Hopefully I can help you here....its a very common thing to happen.


First, I take it you dont know the passwords for console access or telnet/ssh?

I will assume that these devices belong to you.

step 1. Plug a cisco console cable into a serial port on your pc
step 2. Plug other end into Cisco console port
step 3. Using hyperterm or putty or similar connect to the serial port
step 4. boot router, and make sure you clearly can see the output (this confirms you have good serial comms)
step 5. if this fails, adjust the comm port settings (9600, 8,1,n are the default)
step 6. now you have to do the only hard part...send the break command:

Break command list: Break Commands

Go down the list and match your OS and SW and try the sequence suggested.

If this fails several times do what I do: Install putty (free) and then to send a break so you can get into rommom just hit "ctrl-a b".

 

Need some advice on computer problems.

Run HDtune (free version) on you hard drive. but most likely that the problem. You can also test your memory with Memtest86 as suggested above

You didn't list your OS