Forum Discussion

Copper Contributor

Mar 26, 2019

Excel progression tabs / wording

Hello community, I'd greatly appreciate a helping hand if possible! I have an Excel file with a vast amount of data, I have created separate tabs for work progression. In the first tab I hav...

excel

Formulas and Functions

Loobc

Copper Contributor

Mar 27, 2019

Twifoo Thanks for the response!

We use the status to give our figures each day, so preferably I'd like them to remain

Twifoo

Silver Contributor

Mar 27, 2019

If Work1 in Tab1 is Completed, Work1 in Tab2 is Workable. What I want to clarify are these:
1. If Work1 in Tab1 is Workable, what will Work1 in Tab2 be?
2. If Work1 in Tab1 is In Progress, what will Work1 in Tab2 be?
3. If Work1 in Tab1 is Blank, what will Work1 in Tab2 be?

Loobc
Copper Contributor
Mar 28, 2019
Twifoo I only need the completed in tab1 to show as workable in tab2, the other 'statuses' are not needed.

Work1 Tab1 Workable, would show as Blank on Tab2
Work1 Tab1 InProg, would show as Blank on Tab2
Wark1 Tab1 Completed, would show as Workable on Tab2
- Twifoo
  Silver Contributor
  Mar 28, 2019
  Your formula in Sheet2!B2 could be:
  =IF(VLOOKUP(A2,Sheet1!A:B,2,0)="Completed",
  "Workable",
  "")
  - Loobc
    Copper Contributor
    Mar 28, 2019
    Twifoo Thanks, I'm having issues with it returns just '0', I have amended the sheet names and adjusted some of the cells etc but I'm still have issues.
    
    I have attached some pictures for you to see, although they only show as workable on the screen grab further down there are some completed