Forum Discussion
emmapapa2
Dec 09, 2021Copper Contributor
QUESTION ABOUT EXCEL
For date from> = 08/20/1950 to display the value 80 and for date> = 09/20/1950 to <= 10/30/1998 to display the value 60 and for date> = 10/31/1998 to and <= 01/30/2008 to display the value 60! I appl...
- Dec 09, 2021
Here is the sample workbook.
HansVogelaar
Dec 09, 2021MVP
I'd create a small lookup table. In the screenshot below, it is on the same sheet, but it can be on another sheet if you prefer.
Formula in Y5:
=VLOOKUP(X5,$AC$5:$AD$11,2)
emmapapa2
Dec 09, 2021Copper Contributor
if it isn't difficult I want two screenshot in which I wouldlike to see and thw number of bar/cell tobe clear, cause on these pictures a see only the formulas
- HansVogelaarDec 09, 2021MVP
Here is the sample workbook.
- emmapapa2Dec 09, 2021Copper Contributor
HansVogelaar last question! COULD YOU HELP ME???
- HansVogelaarDec 09, 2021MVP
See the attached sample workbook.