-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
column index number
-
E
VLOOKUP Function
Is there a way to have the column index number find it for you without having to count? If I have 50 columns and in the first Vlookup the column index is 10, in the second Vlookup the column index is 40. Example: <colgroup><col span="6"></colgroup><tbody> 1 2 3 4 5...- esgca2010
- Thread
- column index counter column index number index vlookup
- Replies: 6
- Forum: Excel Questions
-
T
Column Index Number Variations
Hi, I have this formula =IF(ISNA(VLOOKUP($A10,INDIRECT($P1&"!A:j"),4,0)=TRUE),0,VLOOKUP($A10,INDIRECT($P1&"!A:j"),4,0)) but I would like to have the column index number variable, so that when I change a look up it will go to another column. I have data in columns 4 through to 10 and would like...- trainer75
- Thread
- column index number formula
- Replies: 5
- Forum: Excel Questions
-
C
When VLOOKUP returns #N/A when there IS AN EXACT MATCH
When: -VLOOKUP fails to recognize your exact data match within the table array, and returns #N/A. I originally called this post VLOOKUP IS BLIND!!!! As I was writing the post asking for help I came up with the clever solution :rolleyes:! Here it is! Copy your data into Notepad and then...- cgifford
- Thread
- #n/a column index number table array vlookup vlookup fails
- Replies: 3
- Forum: Excel Questions
