How to create a vlookup from different sources

[Akumanchai]

Hi. How to create a vlookup from different sources. Results 1 to result 10 should be the same as in table source 2. For information lookup value (C6) is from Dupli S1 and to get results 1 to 10 should be taken from source 2. Thank you for your help.

[bebo021999]

Is it are you looking for?

=VLOOKUP($C6,'SOURCE 2'!$C$6:$O$9,COLUMN(D:D),0)

[Akumanchai]

Thank you very much my friend
PROBLEM SOLVED