1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Help with an Index and Match formula

Discussion in 'Business Applications' started by Pedro14, Jul 6, 2019.

Thread Status:
Not open for further replies.
  1. Pedro14

    Pedro14 Thread Starter

    Joined:
    Jul 6, 2019
    Messages:
    13
    Tech Support Guy System Info Utility version 1.0.0.4
    OS Version: Microsoft Windows 10 Home, 64 bit
    Processor: Intel(R) Core(TM) i5-3330 CPU @ 3.00GHz, Intel64 Family 6 Model 58 Stepping 9
    Processor Count: 4
    RAM: 8071 Mb
    Graphics Card: Intel(R) HD Graphics, -1984 Mb
    Hard Drives: C: 446 GB (186 GB Free); D: 931 GB (692 GB Free);
    Motherboard: Gigabyte Technology Co., Ltd., B75M-D3V
    Antivirus: Norton 360, Enabled and Updated

    Need help to correct the #N/A error message in cell C5 of attached file
    What I want to have in C5 is Phone and if an I is placed in say b6 I want Insurance
     

    Attached Files:

  2. Pedro14

    Pedro14 Thread Starter

    Joined:
    Jul 6, 2019
    Messages:
    13
    Found problem was leading/trailing spaces and all works ok now
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1229598

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice