Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Hakimuddeen bohra , Chief Accountant , AL KHALEEJ TRADING PROJECTS & SUBSIDIARIES
Date Posted: 2014/04/17
FITAH MOHAMED
by 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