VLookup column return issue

[Guest]

I am using Vlookup to find the same item number in 2 seperate workbooks, and
would like the return to be based in the G row. When I enter 7 as the
col_index_num, I am getting a #REF! error. The data I am looking to return is
text, and it was copied from a pivot table report. I tried copying everything
into a new workbook, putting the 2 sheets I am comparing into separte
worksheets within the workbook, thinking it had something to do with the
pivot table or sperate workbooks, but I am still getting the same error. Also
tried formatting the row I am trying to get as a return as text, still
nothing. Any ideas where my problem is? As I walk-around, I am using an IF
statement to lookup the text, but it seems like Vlookup alone should be able
to do this without the additional work, I am using the correct function for
what I want to do?

Thanks,
Jacky D.

 

[Guest]

What is the VLOOKUP formula?

 

[Guest]

ndex_num, I do get the correct return.
=VLOOKUP(A2,'[dashboard-cert.xls]Sheet0'!$A$2:$A$187,7,FALSE)

If I enter 1 for the col_index_num, I do get the correct return.

Thanks

 

[Pete_UK]

Your lookup table is only one column wide, i.e.:

Sheet0'!$A$2:$A$187

To get the 7th column you will need to make this (at least):

Sheet0'!$A$2:$G$187

although it could be wider if elsewhere you need to get more columns.

Hope this helps.

Pete

ndex_num, I do get the correct return.
=VLOOKUP(A2,'[dashboard-cert.xls]Sheet0'!$A$2:$A$187,7,FALSE)

If I enter 1 for the col_index_num, I do get the correct return.

Thanks

What is the VLOOKUP formula?

"Jacky D." wrote:

- Show quoted text -

 

[Guest]

Worked!

Thank you so much!!

Jacky D.

Your lookup table is only one column wide, i.e.:

Sheet0'!$A$2:$A$187

To get the 7th column you will need to make this (at least):

Sheet0'!$A$2:$G$187

although it could be wider if elsewhere you need to get more columns.

Hope this helps.

Pete

ndex_num, I do get the correct return.
=VLOOKUP(A2,'[dashboard-cert.xls]Sheet0'!$A$2:$A$187,7,FALSE)

If I enter 1 for the col_index_num, I do get the correct return.

Thanks

What is the VLOOKUP formula?

"Jacky D." wrote:

I am using Vlookup to find the same item number in 2 seperate workbooks, and
would like the return to be based in the G row. When I enter 7 as the
col_index_num, I am getting a #REF! error. The data I am looking to return is
text, and it was copied from a pivot table report. I tried copying everything
into a new workbook, putting the 2 sheets I am comparing into separte
worksheets within the workbook, thinking it had something to do with the
pivot table or sperate workbooks, but I am still getting the same error. Also
tried formatting the row I am trying to get as a return as text, still
nothing. Any ideas where my problem is? As I walk-around, I am using an IF
statement to lookup the text, but it seems like Vlookup alone should be able
to do this without the additional work, I am using the correct function for
what I want to do?

Thanks,
Jacky D.- Hide quoted text -

- Show quoted text -

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Worked!

Thank you so much!!

Jacky D.

Your lookup table is only one column wide, i.e.:

To get the 7th column you will need to make this (at least):

although it could be wider if elsewhere you need to get more columns.

Hope this helps.

Pete

ndex_num, I do get the correct return.
=VLOOKUP(A2,'[dashboard-cert.xls]Sheet0'!$A$2:$A$187,7,FALSE)
If I enter 1 for the col_index_num, I do get the correct return.
Thanks
:
What is the VLOOKUP formula?
:
I am using Vlookup to find the same item number in 2 seperate workbooks, and
would like the return to be based in the G row. When I enter 7 as the
col_index_num, I am getting a #REF! error. The data I am looking to return is
text, and it was copied from a pivot table report. I tried copying everything
into a new workbook, putting the 2 sheets I am comparing into separte
worksheets within the workbook, thinking it had something to do with the
pivot table or sperate workbooks, but I am still getting the same error. Also
tried formatting the row I am trying to get as a return as text, still
nothing. Any ideas where my problem is? As I walk-around, I am using an IF
statement to lookup the text, but it seems like Vlookup alone should be able
to do this without the additional work, I am using the correct function for
what I want to do?
Thanks,
Jacky D.- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -