Forum Discussion

jcbuc78's avatar
jcbuc78
Copper Contributor
Apr 26, 2019

Excel help

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 ...
excel
jcbuc78's avatar
jcbuc78
Copper Contributor
Apr 27, 2019

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

Twifoo 

 

Twifoo's avatar
Twifoo
Silver Contributor
Apr 28, 2019
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.
  • jcbuc78's avatar
    jcbuc78
    Copper Contributor
    Apr 29, 2019

    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 

Resources