Is the data for Jan in 2 columns in your new sheet? and no limit on rows? And
you say columns which are NOT next to each other ... what exacly do you mean
.... data for Jan then data for Mar??

What is current formula?

"GaryLager" wrote:

Hi, I am trying to create a formula that will look up information from
columns that are not next to each.

Example
A B C D E F G G
1 Jan Jan Feb Feb Mar Mar Apr Apr
2 Sub Adj Sub Adj Sub Adj Sub Adj
3
4 10 20 10 20 10 20 10 20
5 20 10 20 10 20 10 20 10

I have a file with the full year data and I need to read this data into
another spreadsheet. If I put in Jan on my other spreadsheet I want the
information from the Jan columns to be brought over. If I use HLOOKUP it
only brings the Sub information. Hope I explained it ok, please help.