ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Hakimuddeen bohra , Chief Accountant , AL KHALEEJ TRADING PROJECTS & SUBSIDIARIES
تاريخ النشر: 2014/04/17
FITAH MOHAMED
من قبل 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

المزيد من الأسئلة المماثلة