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.

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.

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

"Toppers" wrote:

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.

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


On Jul 5, 4:32 pm, Jacky D. wrote:
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



"Toppers" wrote:
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 -

Worked!

Thank you so much!!

Jacky D.

"Pete_UK" wrote:

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


On Jul 5, 4:32 pm, Jacky D. wrote:
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



"Toppers" wrote:
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 -

You're welcome - thanks for feeding back.

Pete

On Jul 5, 5:08 pm, Jacky D. wrote:
Worked!

Thank you so much!!

Jacky D.



"Pete_UK" wrote:
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

On Jul 5, 4:32 pm, Jacky D. wrote:
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

"Toppers" wrote:
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 -- Hide quoted text -

- Show quoted text -