Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
Old 08-22-2013, 11:23 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline I think I need an IF/AND & VLOOKUP formula here Windows 7 64bit I think I need an IF/AND & VLOOKUP formula here Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

What you did is first select the range C13:C17 then applied the formula on this range as one would do with formula returning arrays.
In fact this formula does NOT RETURN an array, but only a value.
This implies that the RC-2 does not adapt and stays looking for the same value thus giving the same result everywhere
In this case, you should enter the formula ONLY in C13, commit it with Ctrl+Shift+Enter in the formula bar and THEN pull it down.

Your use of RC notation also obscures the fact that the reference to EMPL ID changes on each row. RC-2 visually stays the same when pulled down, so, one would not see that the cell reference stayed unchanged in your example.

To be honest, I am active on several forums since many years and have NEVER seen anyone using the RC notation in formula, except of course for VBA, and I would assume that if it was more efficient to do so, lots of MVP ' s would, but, they don't.
__________________
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
Reply With Quote
 

Tags
if/and, vlookup



Similar Threads
Thread Thread Starter Forum Replies Last Post
VLookup formula Problem (salary plus (commission x sales)) topgear2015 Excel 11 06-05-2013 09:02 PM
I think I need an IF/AND & VLOOKUP formula here VLookup is giving me #N/A error, help with data or formula? ladygogo78 Excel 3 10-22-2012 12:28 AM
IF + VLOOKUP formula help skyline255 Excel 0 09-19-2012 05:05 PM
Help with VLOOKUP formula pattyr Excel 6 08-20-2012 02:20 AM
Using IF & VLOOKUP together junction Excel 7 11-18-2010 05:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft