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

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,919

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 »

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 04:24 PM.