Getting the value of nth column from a different sheet or workbook

**shazydotcom** · 06-24-2012, 08:37 AM

Hi All,

This is my very first post with a question.

I have two work sheets. What I am doing now is that when I manually enter the number 6 for column F from Sheet1, then i get the values of Sheet1 F column in any column of Sheet2 where I have coded the formulas for rows. It was an easy example but what if the columns are going to GG or KK, then is it possible that instead of manually counting the number of column GG, i just put a formula which can bring the number of column FF from worksheet1?

Thanks in advance

**tigertiger** · 06-24-2012, 08:41 AM

Originally Posted by shazydotcom

Hi All,
GG, i just put a formula which can bring the number of column FF from worksheet1?
Thanks in advance

you can use COLUMN function, for examples:

=COLUMN(GG:GG)

or
the number of columns between FF and GG, like that

=COLUMN(GG:GG)-COLUMN(FF:FF)+1