match formula

[paramveer]

Please suggest me formula. the result i want after matching three different data mention in file

 

[paramveer]

Pls somebody help

 

[vletm]

paramveer
How do cell F2 should match someway?
Your chart-sheet has a lot of texts which looks numbers ...
You can find two different formulas in I10 & J10.

 

[paramveer]

sir I also want f2 match with chart A:A

 

[vletm]

paramveer
Did You read my the 1st question?
... how do You want?

 

[paramveer]

Sir,
i upload new sheet in which i asign colour to which i want to match with different sheet.
I want three Match
1) Name of Work (Comparitive F2 = Chart A3)
2) Name of Agency (Comparitive i7 = chart f6)
3) desricption of Item (Comparitive d10= chart b8:b20)
and desired result taken from chart cheet from F8:f20
Thanks in advance

 

[vletm]

paramveer
You seem skipped my given formulas - You should able to copy those as You want.
For Your 1) You could use below to cell F2 ... You skipped to answer - How...?

 

[bosco_yip]

Try,

In "comparitive.2" sheet I10, enter formula and then formula copied right to K10, M10, O10, Q10 and S10 :

=INDEX(chart!$B$1:$Q$1000,MATCH($D10,chart!$B$1:$B$1000,0)+MATCH($F$2,chart!$A$1:$A$1000,0)-3,MATCH(I$7,chart!$B$6:$Q$6,0))

Regards

 

[paramveer]

bosco_yip Thanks sir this formula solve my problem
Thank you very much