Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-29-2015, 04:29 AM
ischilder ischilder is offline Question about VLOOKUP (in Dutch VERT.ZOEKEN) Windows 10 Question about VLOOKUP (in Dutch VERT.ZOEKEN) Office 2013
Novice
Question about VLOOKUP (in Dutch VERT.ZOEKEN)
 
Join Date: Oct 2015
Posts: 1
ischilder is on a distinguished road
Default Question about VLOOKUP (in Dutch VERT.ZOEKEN)

The result of “VERT.ZOEKEN(F1;A:B;2;0)” is 113, that is correct.




Then I insert another column.
VERT.ZOEKEN(F1;A:B;2;0) changes to VERT.ZOEKEN(G1;A:C;2;0).
The changes (F1 to G1) and (A:B to A:C) I can understand.

My question: Why doesn’t change the column number “2” change to “3”?

(See attachment for screenprints)
Attached Files
File Type: docx Question about VLOOKUP-151029.docx (76.5 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Question about VLOOKUP (in Dutch VERT.ZOEKEN) Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question rsrasc Word VBA 7 03-28-2014 12:28 PM
Question: Will Vlookup work on this problem? jnix612 Excel 1 07-27-2013 12:11 AM
vlookup question Tony G Excel 9 03-28-2009 11:16 PM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM
Question about VLOOKUP (in Dutch VERT.ZOEKEN) Change Language From Dutch To English tutwelve Office 7 08-20-2005 07:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:40 PM.


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