Different column formula

[stormania]

Dear Excel Master
Kindly help, how get excel formula from different sheet and column as per attach file.
Base on attach file, how to get formula in yellow cell (growth) that pick from different source sheet & column ?
Thanks in advance

 

[Marcilio]

stormania, Good morning.

If your columns are fixed and the data in column A is unique, maybe the VLOOKUP function can help you.
It's a simple formula but it works.

Please let us know if this is what you want.
Hope this helps.

 

[stormania]

stormania, Good morning.

If your columns are fixed and the data in column A is unique, maybe the VLOOKUP function can help you.
It's a simple formula but it works.

Please let us know if this is what you want.
Hope this helps.

Dear Marcilio
Some case data in column not fixed, but the header are fixed. But thank you for advice

 

[Michael Gramm]

Convert data to table and use index/match.

 

[stormania]

Dear Excel Master
Maybe any another way because use vlookup, its difficult to find column number position and sometimes not match with header text column
Kindly help...thank you

 

[Marcilio]

stormina, good morning.

Maybe a variation can help.

=VLOOKUP($A3; 'data 1'!$A$3:$N$5; MATCH(C$1; 'data 1'!$A$1:$N$1 ;0) + 3; FALSE)

Does this meet your need?
Hope it helps

 

[stormania]

stormina, good morning.

Maybe a variation can help.

=VLOOKUP($A3; 'data 1'!$A$3:$N$5; MATCH(C$1; 'data 1'!$A$1:$N$1 ;0) + 3; FALSE)

Does this meet your need?
Hope it helps

HOORRAYYY....ITS WORK, THANKS ALOT

 

[Marcilio]

stormina, Good evening.

Thanks for the feedback.

I'm glad to have helped you.