trying to use vlookup to calculate several different situations in one cell

		Microsoft Office Forums > Microsoft Excel > Excel
trying to use vlookup to calculate several different situations in one cell

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-21-2013, 01:35 AM

Pecoflyer

Windows 7 64bit trying to use vlookup to calculate several different situations in one cell

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps replace your empty cells conditions with
=IF(C5="",0,Vlookup... etc..
The "" is causing the error

BTW what is the OR function for?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

formulas, vlookup

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate age	userman	Excel	8	06-02-2012 10:59 PM
How to calculate percentages???	fabthi	Excel	3	04-13-2012 12:08 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Can't calculate formulas	Cpat	Excel	2	06-09-2010 02:07 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:50 AM.