Vlookup against multiple columns/worksheets question

J

JCarter

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!!!
 
C

CLR

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
 
J

JCarter

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

CLR said:
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
Click to expand...
 
J

Jason

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

HTH.

Jason

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

JCarter

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

CLR

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 said:
Nope, they're all over. From Column A to Column O on some, each in
independent cells and rows from A1 to O415.
Click to expand...
 
J

JCarter

Interesting idea, but I think this might work. Thank you very much!!! :eek:)
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
 
C

CLR

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)
 
J

JCarter

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

Take care!
 
Top