vlookup

[jams]

Dear all,

I have an issue, i need to select two coloumns to apply vlook for comaprision for example,

lets i have data in coloumn A and B and i want select this two coulumns and want serach see these data is available in other sheets.


Regards
Jams

 

[jams]

for more reference file is uploaded.
in this file i want to select coloumn A & B at the same time and want to compare this data with other file.

your immediate response is highly appreciated.

 

[NARAYANK991]

Hi ,

Only one file has been uploaded ; what about the second file which has data with which you compare columns A and B of this uploaded file ?

Narayan

 

[srinidhi]

You have to use the Index & Match formula,

Index(result u want to display,MATCH('value to be matched',Range to look up for ,FALSE),1) its an Array Formula

 

[jams]

Dear Narayan,

second file is uploaded for refernce.

sri, i will try your formula but still its not clear to me.


regards
Jams

 

[NARAYANK991]

Hi ,

Can you check the formulae in this file ?

Narayan