Autoincrement the VLOOKUP column index in Excel can't get past column Z [on hold]In Excel 2007 does the data...

The past tense for the quoting particle って

What is the oldest European royal house?

What is "desert glass" and what does it do to the PCs?

The need of reserving one's ability in job interviews

Does the US political system, in principle, allow for a no-party system?

Does the in-code argument passing conventions used on PDP-11's have a name?

How do you make a gun that shoots melee weapons and/or swords?

How to make sure I'm assertive enough in contact with subordinates?

Named nets not connected in Eagle board design

An Undercover Army

3.5% Interest Student Loan or use all of my savings on Tuition?

Under what conditions would I NOT add my Proficiency Bonus to a Spell Attack Roll (or Saving Throw DC)?

What does "rhumatis" mean?

How to chmod files that have a specific set of permissions

A bug in Excel? Conditional formatting for marking duplicates also highlights unique value

Integrating function with /; in its definition

Error in TransformedField

What's the best tool for cutting holes into duct work?

What can I do if someone tampers with my SSH public key?

Is every open circuit a capacitor?

What is better: yes / no radio, or simple checkbox?

How spaceships determine each other's mass in space?

Practical reasons to have both a large police force and bounty hunting network?

Why won't the strings command stop?



Autoincrement the VLOOKUP column index in Excel can't get past column Z [on hold]


In Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself?Trouble getting VLOOKUP to workExcel: VLOOKUP and INDEX+MATCH return #REFIF Statement with VLOOKUPExcel Vlookup range or if functionUsing a Column Name in a VLOOKUPExcel VLOOKUP function returns a value from the wrong row - but no trailing spacesIs it possible to use Index and Match or something similar in Microsoft Excel to find last filled number row for two sets of numbers in same column?Excel - Increment vlookup column index when dragging downDrag formula across column not have it change the row number in Excel 2010













0















I have a simple formula that I was able to copy across all columns in my first sheet. It is a Vlookup command that is pulling data from a sheet called AMR.



It works fine all the way until it gets to column Z...then on the next column "AA" it returns a #REF error.



Here is the command:



=VLOOKUP($F2,AMR!$A$2:$AA$630,COLUMN(Z2)+1,FALSE)


Again every column A-Z works fine until I drag the formula to columns AA, AB, etc...what could be the issue?



Thanks






microsoft-excel worksheet-function vlookup







share|improve this question













put on hold as off-topic by fixer1234, Mokubai♦ 18 hours ago



  • This question does not appear to be about computer software or computer hardware within the scope defined in the help center.

If this question can be reworded to fit the rules in the help center, please edit the question.












  • 1





    I'm voting to close this question as off-topic because OP's self answer says the formula was incorrectly specified. There is no problem to solve and OP requests closure.

    – fixer1234
    19 hours ago
















0















I have a simple formula that I was able to copy across all columns in my first sheet. It is a Vlookup command that is pulling data from a sheet called AMR.



It works fine all the way until it gets to column Z...then on the next column "AA" it returns a #REF error.



Here is the command:



=VLOOKUP($F2,AMR!$A$2:$AA$630,COLUMN(Z2)+1,FALSE)


Again every column A-Z works fine until I drag the formula to columns AA, AB, etc...what could be the issue?



Thanks






microsoft-excel worksheet-function vlookup







share|improve this question













put on hold as off-topic by fixer1234, Mokubai♦ 18 hours ago



  • This question does not appear to be about computer software or computer hardware within the scope defined in the help center.

If this question can be reworded to fit the rules in the help center, please edit the question.












  • 1





    I'm voting to close this question as off-topic because OP's self answer says the formula was incorrectly specified. There is no problem to solve and OP requests closure.

    – fixer1234
    19 hours ago














0












0








0








I have a simple formula that I was able to copy across all columns in my first sheet. It is a Vlookup command that is pulling data from a sheet called AMR.



It works fine all the way until it gets to column Z...then on the next column "AA" it returns a #REF error.



Here is the command:



=VLOOKUP($F2,AMR!$A$2:$AA$630,COLUMN(Z2)+1,FALSE)


Again every column A-Z works fine until I drag the formula to columns AA, AB, etc...what could be the issue?



Thanks






microsoft-excel worksheet-function vlookup







share|improve this question














I have a simple formula that I was able to copy across all columns in my first sheet. It is a Vlookup command that is pulling data from a sheet called AMR.



It works fine all the way until it gets to column Z...then on the next column "AA" it returns a #REF error.



Here is the command:



=VLOOKUP($F2,AMR!$A$2:$AA$630,COLUMN(Z2)+1,FALSE)


Again every column A-Z works fine until I drag the formula to columns AA, AB, etc...what could be the issue?



Thanks






microsoft-excel worksheet-function vlookup




microsoft-excel worksheet-function vlookup






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 23 hours ago









user3105519user3105519

1




1




put on hold as off-topic by fixer1234, Mokubai♦ 18 hours ago



  • This question does not appear to be about computer software or computer hardware within the scope defined in the help center.

If this question can be reworded to fit the rules in the help center, please edit the question.







put on hold as off-topic by fixer1234, Mokubai♦ 18 hours ago



  • This question does not appear to be about computer software or computer hardware within the scope defined in the help center.

If this question can be reworded to fit the rules in the help center, please edit the question.








  • 1





    I'm voting to close this question as off-topic because OP's self answer says the formula was incorrectly specified. There is no problem to solve and OP requests closure.

    – fixer1234
    19 hours ago














  • 1





    I'm voting to close this question as off-topic because OP's self answer says the formula was incorrectly specified. There is no problem to solve and OP requests closure.

    – fixer1234
    19 hours ago








1




1





I'm voting to close this question as off-topic because OP's self answer says the formula was incorrectly specified. There is no problem to solve and OP requests closure.

– fixer1234
19 hours ago





I'm voting to close this question as off-topic because OP's self answer says the formula was incorrectly specified. There is no problem to solve and OP requests closure.

– fixer1234
19 hours ago










1 Answer
1






active

oldest

votes


















0














Please check the range AMR!$A$2:$AA$630



Column(AA2)+1will return Column AB result and it didn't contain the range in AMR!$A$2:$AA$630



This is the reason of your problem.



You can change the range to AMR!2:630






share|improve this answer






























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Please check the range AMR!$A$2:$AA$630



    Column(AA2)+1will return Column AB result and it didn't contain the range in AMR!$A$2:$AA$630



    This is the reason of your problem.



    You can change the range to AMR!2:630






    share|improve this answer




























      0














      Please check the range AMR!$A$2:$AA$630



      Column(AA2)+1will return Column AB result and it didn't contain the range in AMR!$A$2:$AA$630



      This is the reason of your problem.



      You can change the range to AMR!2:630






      share|improve this answer


























        0












        0








        0







        Please check the range AMR!$A$2:$AA$630



        Column(AA2)+1will return Column AB result and it didn't contain the range in AMR!$A$2:$AA$630



        This is the reason of your problem.



        You can change the range to AMR!2:630






        share|improve this answer













        Please check the range AMR!$A$2:$AA$630



        Column(AA2)+1will return Column AB result and it didn't contain the range in AMR!$A$2:$AA$630



        This is the reason of your problem.



        You can change the range to AMR!2:630







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 19 hours ago









        LeeLee

        91427




        91427















            -

            Popular posts from this blog

            Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

            Image
            Why didn't Boeing produce its own regional jet? What is the most common color to indicate the input-field is disabled? Theorists sure want true answers to this! What is the opposite of "eschatology"? What do you call someone who asks many questions? Is there a hemisphere-neutral way of specifying a season? Is this draw by repetition? Bug? String.split chopping off empty trailing value Is it inappropriate for a student to attend their mentor's dissertation defense? How dangerous is XSS Why do I get negative height? Is it possible to map
            Read more

            VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

            Image
            risk of flooding in petra in november How to get directions in deep space? How could a planet have erratic days? 15% tax on $7.5k earnings. Is that right? Did the UK lift the requirement for registering SIM cards? Is it allowed to activate the ability of multiple planeswalkers in a single turn? Stack Interview Code methods made from class Node and Smart Pointers Non-trope happy ending? What is the highest possible scrabble score for placing a single tile Open a doc from terminal, but not by its name The IT department bottlenecks progress, how should I handle this?
            Read more

            Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...

            Image
            Does the Mueller report show a conspiracy between Russia and the Trump Campaign? Relating to the President and obstruction, were Mueller's conclusions preordained? How much damage would a cupful of neutron star matter do to the Earth? Nose gear failure in single prop aircraft: belly landing or nose landing? Should a wizard buy fine inks every time he want to copy spells into his spellbook? Can you force honesty by using the Speak with Dead and Zone of Truth spells together? A trigonometry question from STEP examination Special flights What is the "studentd" process? systemd and copy (/bin/cp): no such file or directory
            Read more