CANNOT SEE THE COLUMN IS IN WHICH ORDER

%3CLINGO-SUB%20id%3D%22lingo-sub-2334603%22%20slang%3D%22en-US%22%3ECANNOT%20SEE%20THE%20COLUMN%20IS%20IN%20WHICH%20ORDER%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2334603%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20with%20very%20big%20data%20by%20using%20VLOOKUP.%20While%20I%20am%20choosing%20the%20table%20array%2C%20I%20need%20to%20the%20small%20notification%20on%20the%20attached%20photo%20which%20I%20was%20able%20to%20before%3A....x5C%2C%20therefore%20I%20was%20writing%205%3A0%20on%20the%20VLOOKUP%20formula.%20But%20now%20I%20cannot%20count%20everytime%20the%20last%20column%20that%20I%20marked%20is%20in%20which%20order%20like%20A%20B%20C%20...%20X%20Y%20Z.%20How%20can%20I%20make%20it%20this%20notification%20appear%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2334603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2338308%22%20slang%3D%22en-US%22%3ERe%3A%20CANNOT%20SEE%20THE%20COLUMN%20IS%20IN%20WHICH%20ORDER%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338308%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047707%22%20target%3D%22_blank%22%3E%40tdonmez17%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20I%20was%20not%20able%20to%20catch%20up%20with%20your%20query%2C%20could%20you%20please%20attached%20a%20sample%20file%20with%20the%20annotating%20your%20issue%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2338412%22%20slang%3D%22en-US%22%3ERe%3A%20CANNOT%20SEE%20THE%20COLUMN%20IS%20IN%20WHICH%20ORDER%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338412%22%20slang%3D%22en-US%22%3EI%20don't%20know%20how%20to%20fix%20the%20row%2Fcolumn%20counter%2C%20but%20another%20option%20could%20be%20to%20use%20the%20columns%20function%20in%20the%20formula%20instead%20of%20counting%20the%20columns%20yourself.%20For%20example%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3DVLOOKUP(G1%2CA1%3AE10%2CCOLUMNS(A1%3AC1)%2CFALSE)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339361%22%20slang%3D%22en-US%22%3ERe%3A%20CANNOT%20SEE%20THE%20COLUMN%20IS%20IN%20WHICH%20ORDER%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339361%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecould%20you%20share%20sample%20data%2C%20what%20I%20can%20see%20your%20are%20trying%20to%20get%20the%20column%20number%20from%20the%20header%20value.%20this%20might%20be%20helpful%20for%20you.%3C%2FP%3E%3CP%3EMake%20VLOOKUP%20Column%20Index%20Dynamic%20(Mac%20%26amp%3B%20Windows)%20-%20%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FW8g5jhYV-8M%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FW8g5jhYV-8M%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I am working with very big data by using VLOOKUP. While I am choosing the table array, I need to the small notification on the attached photo which I was able to before:....x5C, therefore I was writing 5:0 on the VLOOKUP formula. But now I cannot count everytime the last column that I marked is in which order like A B C ... X Y Z. How can I make it this notification appear again?

5 Replies

Hi @tdonmez17,

 

Sorry, I was not able to catch up with your query, could you please attached a sample file with the annotating your issue 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

I don't know how to fix the row/column counter, but another option could be to use the columns function in the formula instead of counting the columns yourself. For example,

=VLOOKUP(G1,A1:E10,COLUMNS(A1:C1),FALSE)

Hi @JMB17 

 

could you share sample data, what I can see your are trying to get the column number from the header value. this might be helpful for you.

Make VLOOKUP Column Index Dynamic (Mac & Windows) - https://youtu.be/W8g5jhYV-8M

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Thanks, but I think you're replying to the wrong person.
Oops , sorry to tag you @JMB17