Forum Discussion
Index Match Help
Hi, I was hoping someone could help me with a formula. I am trying to pull the data from the assumptions tab into the leads tab by reading the property type (C column), zipcode (M column) and beds t...
Brady,
provided that zip codes and number of beds are the same and in the same order for both tables.
_table=MATCH(C2,{"Residential";"Condominium"},0)
_row=MATCH(M2,Assumptions!$B$5:$B$28,0)
_column=MATCH(P2,Assumptions!$C$4:$F$4,0)
FD2=INDEX((Assumptions!$C$5:$F$28;Assumptions!$Q$5:$T$27);_row;_column;_table)
This worked. Thank you very much.