Excel help

[jcbuc78]

Hello Excel experts

I need some help, been pluging around on google for hours and while got it close to work, can't get this nailed down.

See attached file

For column A:B, I am looking to input a formual in column E through H to caputre each example in column A:B

I had tried to create a drop down list for each header, then do an array lookup, was semi sucesful but could not get it to ignore duplciates.

Hope the above + attachment makes sense :) 

[#2]

In F2, you may use this formula, copied down rows and across columns:
=INDEX($B:$B,
MATCH($E2,$B:$B,0)+
MATCH(F$1,$A$3:$A$6,0))

[#3]

@Twifoo 

If paste in exaclty as is, I think it not looking at the right cells.

example, shouldn't the formual start in column E2 not F2?  Should be matching stating at A2 not A3, see the screen shot attached of what happens when pasted as is. 

[#4]

Thank you for helping, here is the screen shot of what is happing

@Twifoo 

[#5]

The formula I suggested presupposes that E2 contains the lookup_value. You deleted the lookup_value, thereby effectively making blank cell as the lookup value.

[#6]

ok NOW i see, small misunderstanding. What I was seeking was a formula to get the info from column B and populate into E, F, G, H, by matching the column headers compared to column A but not give duplicates. But not having to manually fill in column E (address). So that's why I deleted info, I thought the formula was going to do the work not dependent on manually typing in column E

does that make sense?

 @Twifoo