Vlookup sheets

[tonijel]

Hello guys,
i would be greatful for some advice.
I have excel file with 3 sheets in it filled with some data.
Sheet 1 is data from 2 years ago,sheet 2 is from 1 year ago and sheet 3 is data from now.
Field A in every sheet contains some number that is either smaller or bigger from the number in field A in other sheets , so this is some value that is changing through some time.
Now I inserted sheet 4 in which I would like to somehow see in column A values from column A from sheet 1 column A, in column B values from column B sheet 2 and so on...
Anyone ?

[davesexcel]

Hello guys,
i would be greatful for some advice.
I have excel file with 3 sheets in it filled with some data.
Sheet 1 is data from 2 years ago,sheet 2 is from 1 year ago and sheet 3 is data from now.
Field A in every sheet contains some number that is either smaller or bigger from the number in field A in other sheets , so this is some value that is changing through some time.
Now I inserted sheet 4 in which I would like to somehow see in column A values from column A from sheet 1 column A, in column B values from column B sheet 2 and so on...
Anyone ?

Check out this example on Vlookup other sheets
http://www.excelforum.com/attachment...1&d=1184905994

[tonijel]

Hi Dave,
thanks for replying .
I think your suggestion will help me.
Could you please clearify me meanings of bold and underlined numbers in sheet1 ,function in C2 = VLOOKUP($A$2;Sheet2!$A$1:$C$5;2;FALSE)
and in C3 is
VLOOKUP($A$2;Sheet2!$A$1:$C$5;3;FALSE)

[kwright90]

The numbers you have underlined signify which column the vlookup is pulling information from. For instance.. if you have Column A, B, C, and D in your Table Array, then Column A = 1, Column B = 2, Column C = 3, and Column D = 4.

[davesexcel]

Hi Dave,
thanks for replying .
I think your suggestion will help me.
Could you please clearify me meanings of bold and underlined numbers in sheet1 ,function in C2 = VLOOKUP($A$2;Sheet2!$A$1:$C$5;2;FALSE)
and in C3 is
VLOOKUP($A$2;Sheet2!$A$1:$C$5;3;FALSE)

$A$2 is the criteria to lookup
Sheet2!$A$1:$C$5 is the entire data range
2 is the # of columns in that data range you want to display