Apr 25 2019 05:18 PM
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 :)
Apr 25 2019 09:59 PM
Apr 27 2019 02:35 PM
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.
Apr 27 2019 02:36 PM
Apr 27 2019 09:18 PM
Apr 29 2019 09:50 AM
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?