Personnel Area

[MARKEGANDERSON]

Hello Guys

On my "Personnel Area tab" lists:

My define name Per_Area_Location (A1:A14- List 14 diff countries)

Per_Area_Ins(B1:F1 - List 5 types of Ins)

Cell B2:F14 list the codes for each country.


How can I build a formula to search for a specific country (Per_Area_Location) and a Specific Insurance( Per_Area_Ins), if the criterias are met produce the info in cells B2:F14

 

[Aladin Akyurek]

Define Personnel as referring to:

='Personnel Area tab'!$A$1:$F$14

Then try:

=VLOOKUP(X2,Personnel,MATCH(Y2,INDEX(Personnel,1,0),0),0)


where X2 houses a specific country of interest and Y2 a specific insurance of interest.

 

[MARKEGANDERSON]

Aladin...As always, Thanks a million!!!!!!!!!!

 

[Aladin Akyurek]

Aladin...As always, Thanks a million!!!!!!!!!!

Glad to help.