Vlookup against multiple columns/worksheets question
 

I have expenses that when imported from the web, come into Excel all over the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and there's no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not able to
get anything to work. Any guidance from the guru's is greatly appreciated!!!
--
JCarter
Still Learning

Although it may look like things are strewn "all over the place", they may
actually "be" all in Column A..........check it out, and if so, the Data
TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place", they may
actually "be" all in Column A..........check it out, and if so, the Data
TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

In order to get Vlookup work, you need to sort the two columns in ascending
order.

HTH.

Jason

"JCarter" wrote:

Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place", they may
actually "be" all in Column A..........check it out, and if so, the Data
TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

Since there's multiple columns in random locations, maybe Vlookup isn't the
function for this task. Any ideas on what could be?

"Jason" wrote:

In order to get Vlookup work, you need to sort the two columns in ascending
order.

HTH.

Jason

"JCarter" wrote:

Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place", they may
actually "be" all in Column A..........check it out, and if so, the Data
TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

If there be only one cell in each row that contains a value, maybe you could
consolidate it all into one column with CONCATENATE(A1,B1,C1.......O1)

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place", they
may
actually "be" all in Column A..........check it out, and if so, the Data

TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all
over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and
there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not
able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

Interesting idea, but I think this might work. Thank you very much!!! :o)
BTW, on just one of these worksheets, the data starts in Column A and goes
to column BA. But each row is shifted over randomly, so this will be a
tricky multiple Concatenate formula.
Thank you again for the idea


"CLR" wrote:

If there be only one cell in each row that contains a value, maybe you could
consolidate it all into one column with CONCATENATE(A1,B1,C1.......O1)

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place", they
may
actually "be" all in Column A..........check it out, and if so, the Data

TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel all
over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets within a
single Excel file, but now I have to pull this all together, and
there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but not
able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

You're welcome.......glad to help.........and maybe you might need the TRIM,
LEFT, RIGHT, or other TEXT functions to help clean things up also.........of
course, once you determine the procedure, you can record it all into a macro
for subsequent use if needed..........

Vaya con Dios,
Chuck =SUM(091938,USMCe4,CABGx3,MMOUS2k)



"JCarter" wrote in message
...
Interesting idea, but I think this might work. Thank you very much!!!
:o)
BTW, on just one of these worksheets, the data starts in Column A and goes
to column BA. But each row is shifted over randomly, so this will be a
tricky multiple Concatenate formula.
Thank you again for the idea


"CLR" wrote:

If there be only one cell in each row that contains a value, maybe you
could
consolidate it all into one column with CONCATENATE(A1,B1,C1.......O1)

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place",
they
may
actually "be" all in Column A..........check it out, and if so, the
Data

TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel
all
over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets
within a
single Excel file, but now I have to pull this all together, and
there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but
not
able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning

My plan exactly! Thank you again for your time and patience with me on this.
I can now tackle other horizons!

Take care!

"CLR" wrote:

You're welcome.......glad to help.........and maybe you might need the TRIM,
LEFT, RIGHT, or other TEXT functions to help clean things up also.........of
course, once you determine the procedure, you can record it all into a macro
for subsequent use if needed..........

Vaya con Dios,
Chuck =SUM(091938,USMCe4,CABGx3,MMOUS2k)



"JCarter" wrote in message
...
Interesting idea, but I think this might work. Thank you very much!!!
:o)
BTW, on just one of these worksheets, the data starts in Column A and goes
to column BA. But each row is shifted over randomly, so this will be a
tricky multiple Concatenate formula.
Thank you again for the idea


"CLR" wrote:

If there be only one cell in each row that contains a value, maybe you
could
consolidate it all into one column with CONCATENATE(A1,B1,C1.......O1)

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.

"CLR" wrote:

Although it may look like things are strewn "all over the place",
they
may
actually "be" all in Column A..........check it out, and if so, the
Data

TextToColumns feature may help you organize things.

Vaya con Dios,
Chuck, CABGx3


"JCarter" wrote in message
...
I have expenses that when imported from the web, come into Excel
all
over
the
place, random columns, cells and rows.

I have combined all our departments onto their own worksheets
within a
single Excel file, but now I have to pull this all together, and
there's
no
rhyme or reason as to how the data is pulled in.

How would I organize this data? I leaning towards Vlookup, but
not
able
to
get anything to work. Any guidance from the guru's is greatly
appreciated!!!
--
JCarter
Still Learning