Forum Discussion
Get latest status on an overview sheet
See the attached sample workbook.
See the attached sample workbook.
HansVogelaar Thanks a lot!
A next question:
I want a number in the selected cell. The number is a representation of the Status.
The correspending number can be found in another table:
Then with the number I want to be able to calculate what percentage is busy, and in the overview tab I want a row with pictograms (red(#2), yellow(#1), green(#0).
When I try to do it now, it doesn't work. I use this formula:
=SEARCH([@Status];Table3[Status];Table3[Code])
But it gives me the wrong code back, so I'm not sure where it goes wrong.
This is what I have now:
https://1drv.ms/x/s!AoVAAPcVWxf-heN4IYJxjTMSg4m5ew?e=bhfrYG
Do you have Microsoft 365 or Office 2021? If so, you can use
=XLOOKUP([@Status];StatCod[Status];StatCod[Code])
Otherwise:
=VLOOKUP([@Status];StatCod;2;FALSE)
See the attached version.
