Forum Discussion
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 ...
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))
=INDEX($B:$B,
MATCH($E2,$B:$B,0)+
MATCH(F$1,$A$3:$A$6,0))
- 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.
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?