| Date | Parameter A |
|---|---|
| 2022.12.05 08:00:00 | 3 |
| 2022.12.05 08:15:00 | 4 |
| 2022.12.05 08:45:00 | 7 |
| Date | Parameter A |
|---|---|
| 2022.12.05 08:00:00 | |
| 2022.12.05 08:15:00 | |
| 2022.12.05 08:30:00 | |
| 2022.12.05 08:45:00 |
I have 2 tables, the first one is the data table that I get daily from a source and the second one is a static date table where there are date information for every 15 minutes.
The problem is, as you can see in the first table, I didn't get 08:30 info because there wasn't parameter information in the source.
How can I insert the data with matching dates? And If there is no info at a specific time, I want it to insert "No Data" to that row.
The final table should look like this;
| Date | Parameter A |
|---|---|
| 2022.12.05 08:00:00 | 3 |
| 2022.12.05 08:15:00 | 4 |
| 2022.12.05 08:30:00 | No Data |
| 2022.12.05 08:45:00 | 7 |
Thank you.
I tried to use "Vlookup" function but it didn't work.
CodePudding user response：
I got this to work below. When you say your VLOOKUP didn't work what happened? Those types of things are helpful to help us help you. Also it doesn't hurt to show us what you tried. Hope this helps!
=IFERROR(VLOOKUP(A1,$D:$e,2,0),"No Data")
