Tech Support Guy banner
Status
Not open for further replies.

Create New Table Based on Cell Values

584 views 1 reply 2 participants last post by  Promor 
#1 ·
I have a worksheet that contains a budget, some of the line items are identified as allowances in column C, by the "allow" designation. The description of the allowance is in column B.

I want to create an automatic table on a worksheet called "Allowances" which searches column C for "allow", and if found returns the description from column B in cell A and the amount of the allowance from column F, in cell B.

Any suggestions?

Thanks,
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top