Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the formula we use for getting particular information maching with unique field from same row of data, IN EXCEL

user-image
Question ajoutée par Hakimuddeen bohra , Chief Accountant , AL KHALEEJ TRADING PROJECTS & SUBSIDIARIES
Date de publication: 2014/04/17
FITAH MOHAMED
par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

first your question need more explain

any way there are many formula we can use to match data 

*

if your array (A1:E1) and  cell A1 contain unique value  and you want the informations in cell "B1" OR "C1" OR" D1" OR" E1" whatever 

 

to getting particular information matching with the unique value 

 

put these same unique value in cell A3

select cell B3 and put these formula 

=INDEX(A1:F1;MATCH(A3;A1:F1;0);2)

 

you will get in formation in cell B1

or this formula 

=VLOOKUP(A3;A1:F1;2;0)

 

****  notes 

A3 = LOOK UP VALUE  "CRITERIA "" " THE UNIQUE VALUE " IN CELL A1 "

"A1:E1" the array of data 

2 =" the column number " if you need information in cell "B1"

3= " the column number" if you need information in cell "C1"

4=" the column number" if you need information in cell "D1"

5 =" the column number" if you need information in cell "E1

More Questions Like This