Question about Microsoft Excel for PC
I have used a vlook up formula (which works) however when the result is found I need the code to look to the cell on left and if the cell contains a particular word I need the value placed, if not I would like it to be 0.
Vlookup can only locate values within the lookup range and to the right of the lookup column. to address your concern, i'd advise you to create a dummy column within the lookup range (and hide it) and link it to the lookup column. this way, we won't need a (-) column index number.
Posted on Nov 17, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 19, 2016 | Computers & Internet
on Nov 11, 2013 | Microsoft Excel Computers & Internet
Dec 17, 2009 | Microsoft Office Home and Student 2007...
Sep 18, 2009 | Microsoft Excel for PC
Jan 13, 2009 | Computers & Internet
Dec 18, 2008 | Microsoft Excel for PC
Nov 15, 2007 | Computers & Internet
Sep 11, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
80 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: