Admin Lady
New Member
- Joined
- Oct 21, 2003
- Messages
- 9
I am trying to create a formula that will pull the word value from one range of cells and match it to another range of cells if the word indicated is listed.
SEE EXAMPLE for clarification
A B
Suite # Space
101 Leased
102 VACANT
103 VACANT
What I need is if the B cells say VACANT, then the value of the cell I am creating the formula in will input the Suite # (A Cells) that associates with the VACANT cell.
Does this make sense????? Please HELP!!
SEE EXAMPLE for clarification
A B
Suite # Space
101 Leased
102 VACANT
103 VACANT
What I need is if the B cells say VACANT, then the value of the cell I am creating the formula in will input the Suite # (A Cells) that associates with the VACANT cell.
Does this make sense????? Please HELP!!